Hi,
I have data that I converted from txt. The problem is, upon conversion it has spaces at the end. For example:
"Monkey "
"Elephant "
"Birds "
What I need to do to remove the spaces?
Hi,
I have data that I converted from txt. The problem is, upon conversion it has spaces at the end. For example:
"Monkey "
"Elephant "
"Birds "
What I need to do to remove the spaces?
Last edited by mridzuani; 05-05-2009 at 07:23 AM.
Try using the TRIM Function
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Great!! Something new for me. Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks