remove trailing spaces

Guest · Jan 20, 2006

I have imported a file that has an undetermined number of spaces after a text
entry. I need to strip those spaces out so my Vlookup will work. Really
appreciate any help.

Example
Cell A1 - contents Z01000 (plus 3 blanks) need to have just Z01000.

Guest · Jan 20, 2006

Hi

Try a helper column with
=TRIM(A1)
in it.

Hope this helps.
Andy.

Guest · Jan 20, 2006

You can use Find and Replace. Put a space in find and nothing in replace.

Guest · Jan 20, 2006

Thank you very much. It worked and I am back in business.

Guest · Jan 20, 2006

Appreciate your suggestion. Thanks.

Sloth said:
You can use Find and Replace. Put a space in find and nothing in replace.

How do you remove trailing spaces withour Trim function?	8	Jul 27, 2009
Macro to remove trailing spaces in cells	2	Jun 11, 2010
Excel 2002 : How to remove trailing spaces ?	4	Apr 6, 2007
How keep Leading/Trailing spaces when save in Excel?	0	Aug 1, 2006
Deleting leading spaces in a cell	4	May 4, 2007
Import Trailing Spaces	8	Dec 4, 2008
How can i remove spaces?	1	Mar 9, 2007
format to a specific number of spaces	2	May 5, 2009

remove trailing spaces

Guest

Guest

Guest

Guest

Guest

Ask a Question

Similar Threads