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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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