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?
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?
use trimall macro in the following url
http://www.mvps.org/dmcritchie/excel/join.htm
=================
sarah_jane <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks