Delete empty spaces at the end of text of a column?
 

I have a column that has different headings that I want to group
together. They are entries made by different people, some people for
one reason or another add an extra space or 2 with the spacebar after
the entry. When grouping these with a pivot table this makes it more
difficult as an entry with an extra space at the end won't group with
the entry without the space.

Is there a way to take a column that has many text entries and delete
any spaces after the last word of them?

Thanks,

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=569399

Delete empty spaces at the end of text of a column?
 

look in help for
TRIM

--
Don Guillett
SalesAid Software

"nbaj2k" wrote in
message ...

I have a column that has different headings that I want to group
together. They are entries made by different people, some people for
one reason or another add an extra space or 2 with the spacebar after
the entry. When grouping these with a pivot table this makes it more
difficult as an entry with an extra space at the end won't group with
the entry without the space.

Is there a way to take a column that has many text entries and delete
any spaces after the last word of them?

Thanks,

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile:
http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=569399