Trim Function in Microsoft Excel 2010

In this article we will learn how to delete the unnecessary blank character from a cell, we will use “TRIM” function in Microsoft Excel 2010.

TRIM: Trim function is used to remove additional leading and trailing spaces from the text in a cell.

Syntax of “TRIM” function:           =TRIM (text)

Example:

  • Cell A2 contains the text“Excel     Tips”
  • Enter the formula in cell B2 =TRIM(A2), press Enter on your keyboard
  • The function will return the text after deleting the unnecessary spaces.

img1

Let’s take an example to understand how and where we can use TRIM function.

For Example:- We have 2 data sets, 1st data is having all details, and we want the 2nd data to pick the date of joining, by using the Employee name.

img2

Employee names are with spaces, and we will use here TRIM function along with Vlookup function.

Follow below given steps:-

  • Write the formula in cell F2.
  • =VLOOKUP(TRIM(E3),A2:B7,2,FALSE)
  • Press Enter on your keyboard.
  • The function will return Date of Joining for agent.

img3

  • Copy the formula by pressing the key Ctrl+C and paste in the range F3:F7 by pressing the key Ctrl+V on your keyboard.

img4

This is the way we can use TRIM function for our data in Microsoft Excel. 

Users are saying about us...

  1. Pingback: jesse

  2. Pingback: leslie

  3. Pingback: casey

  4. Pingback: Kirk

  5. Pingback: Leroy

  6. Pingback: william

  7. Pingback: Fernando

  8. Pingback: Chester

  9. Pingback: Herman

  10. Pingback: Gerald

  11. Pingback: alfonso

  12. Pingback: Bradley

  13. Pingback: gordon

  14. Pingback: kyle

  15. Pingback: luther

  16. Pingback: Ted

  17. Pingback: Oliver

  18. Pingback: Louis

  19. Pingback: dave

  20. Pingback: Homer

  21. Pingback: felix

  22. Pingback: Trevor

  23. Pingback: Neil

  24. Pingback: Charles

  25. Pingback: clarence

  26. Pingback: Victor

  27. Pingback: Nelson

  28. Pingback: Anthony

  29. Pingback: Henry

  30. Pingback: david

  31. Pingback: Roland

  32. Pingback: Derek

  33. Pingback: terry

  34. Pingback: enrique

  35. Pingback: tommy

  36. Pingback: chris

  37. Pingback: glen

  38. Pingback: lawrence

  39. Pingback: jonathan

  40. Pingback: Terrence

  41. Pingback: harold

  42. Pingback: Byron

  43. Pingback: Rene

  44. Pingback: anthony

  45. Pingback: ernesto

  46. Pingback: Ross

  47. Pingback: randall

  48. Pingback: Jamie

  49. Pingback: arnold

  50. Pingback: stephen

  51. Pingback: Ross

  52. Pingback: justin

  53. Pingback: Eugene

  54. Pingback: Vernon

  55. Pingback: adrian

  56. Pingback: leon

  57. Pingback: mario

  58. Pingback: Gabriel

  59. Pingback: jack

  60. Pingback: Wade

  61. Pingback: sidney

  62. Pingback: nicholas

  63. Pingback: pedro

  64. Pingback: max

  65. Pingback: oscar

  66. Pingback: Guy

  67. Pingback: mike

  68. Pingback: glen

  69. Pingback: Jessie

  70. Pingback: Louis

  71. Pingback: floyd

  72. Pingback: leslie

  73. Pingback: paul

  74. Pingback: Ian

  75. Pingback: jay

  76. Pingback: philip

  77. Pingback: eddie

  78. Pingback: lynn

  79. Pingback: julius

  80. Pingback: Sergio

  81. Pingback: curtis

  82. Pingback: chester

  83. Pingback: franklin

  84. Pingback: Perry

  85. Pingback: jorge

  86. Pingback: Darrell

  87. Pingback: ronald

  88. Pingback: martin

  89. Pingback: Wendell

  90. Pingback: Michael

  91. Pingback: benjamin

  92. Pingback: lewis

  93. Pingback: jim

  94. Pingback: alvin

  95. Pingback: Darrell

  96. Pingback: Evan

  97. Pingback: max

  98. Pingback: kyle

  99. Pingback: edwin

  100. Pingback: joey

  101. Pingback: ronald

  102. Pingback: Oscar

  103. Pingback: Arthur

  104. Pingback: Alexander

  105. Pingback: Tracy

  106. Pingback: Edward

  107. Pingback: Dwayne

  108. Pingback: Angelo

  109. Pingback: trevor

  110. Pingback: micheal

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube