Removing space in Column A

angie.chang · #1 06-17-2012, 06:53 PM

Is there any formula to remove space in a column? For example is there a easy formula that I can hightlight the entire column A and remove any space in front of the text?

MakeFordFordFordFord RenaultRenaultBMWBMWBMW

Colin Legg · #2 06-18-2012, 03:11 AM

Hi Angie,

The TRIM() worksheet function can be used to remove spaces at the start and end of a cell's text.
The SUBSTITUTE() worksheet function can be used to remove spaces from all parts of a cell's text.

Does that help?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
autocorrect double space to single space	frankjake	Word	8	09-21-2018 05:44 PM
How to obtain the column “C” from column “A” and “B”?	Jamal NUMAN	Excel	2	02-26-2012 01:28 PM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column	carpat	Excel	0	01-10-2012 09:34 AM
Is this a Tab space or Indentation space?	Jamal NUMAN	Word	1	06-30-2011 05:09 PM
Need to search a column for a macth and return a result from a third column	pdfaust	Excel	2	02-03-2011 03:02 PM