Microsoft Office Forums - View Single Post - Removing space in Column A

Thread: Removing space in Column A

View Single Post

Old

06-18-2012, 03:11 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

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?

Reply With Quote