Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you remove excess spaces from an Excel field?
I have 9000+ fields that have excess spaces at the front of each figure.
I have tried to use the TRIM function but have not met with teh desired result. Is there an easy/quick way of removing the excess spaces? |
#2
|
|||
|
|||
use trimall macro in the following url
http://www.mvps.org/dmcritchie/excel/join.htm ================= sarah_jane wrote in message ... I have 9000+ fields that have excess spaces at the front of each figure. I have tried to use the TRIM function but have not met with teh desired result. Is there an easy/quick way of removing the excess spaces? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
Remove 1st 3 characters in each field of Excel column | Excel Worksheet Functions | |||
Remove empty rows in excel? | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) |