Hi,
I have data in Excel, in which in a column I have 300 and more words. Every cell have extra spaces and I need to delete extra spaces from the data. So I am using Trim function to delete the extra spaces but the result I am getting same as before it was.
Please help me to delete the extra spaces from the data.
Thanks
This could be the result of several causes. Why don't you post some sample data so we can have a look?
BSB
The macro at this website will remove all leading/trailing
and multiple interspersed char 32 space characters.
It will also remove and/or convert char 160 non breaking
spaces into standard char 32 space characters. It will
work on text or numbers and the numbers will be
converted to true numeric numbers.
I use this macro dozens of times every single day!
It's a real time saver.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks for the link. Very slick.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
------
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks