LinkBack URL
About LinkBacks
Hi all,
Please help me in deleting first space.
Regards,
Vikas
Hi all,
Please help me in deleting first space.
Regards,
Vikas
try =trim(a1) in the first instance, but if you have a CHAR 160 in the text, you'll need this:
=SUBSTITUTE(TRIM(A1),CHAR(160),"")
Last edited by Glenn Kennedy; 05-21-2015 at 08:18 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
try using TRIM()
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Glenn - What is CHAR 160?
It's a non-breaking space. Frequently found on stuff downloaded from the www, it often causes formulae to fail, lookups, etc, as the writer isn't aware that it's there. TRIM doesn't get rid of it so SUBSTITUTE is needed.
Take a look at the attachment to Post 4 in this thread from a couple of days ago...
http://www.excelforum.com/excel-form...hing-text.html
Thanks for the explanation Glenn!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks