TRIM function

This function allows remove all spaces from a text apart from single spaces between separate words.

 

Syntax

 

TRIM(Text)

  • Text (required) – This is the text you want to remove extra spaces from.

 

Example

 

In this example we use the function on the text “These     extra   spaces        are annoying!     ” to remove the excess spaces and result in the text “These extra spaces are annoying!”.

 

=TRIM(A2)

 

TRIM

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Related Posts

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us on social media to stay up to date with the latest in Microsoft Excel!