removing leading/trailing spaces

[pholt33]

For one of my processes, I need to email (in the body of the email) imformation to someone else (for various reasons, I cant send as anything other than the body of an email). That person copies the email and pastes into a template. Somewhere in the emailing process, a leading and trailing space is added to each item in a specific column. I tried using =trim but that didnt do anything. How can I get rid of those spaces? It would be awesome if it could happen automatically once the other person pasted the info into their template.

Thanks

 

[Brian from Maui]

Try ASAP Utilities

www.asap-utilities.com

or do a board search for a Trim All Macro

 

[pholt33]

ASAP is great, but I need something that will work on at 4 peoples computers, preferably without them having to think about it.

 

[pholt33]

bump

 

[johnr715]

if the data in ur column is text u could do the following:

select data>text to column>delimited and choose space

if the data in ur column is a number u could use the formula:
=value(A2)

this converts text 2 numbers