I've downloaded some stock codes from a website such as the following, and can't remove
leading spaces with the Alignment function or TRIM() - any suggestions please?
AA
AABA
AAL
ABCB
*ABGLF
ABNK
ABT
etc...
and just now I noticed that when I entered the data here an asterisk appeared in front of one -
would this be some sort of hidden character?
Last edited by jp001; 10-06-2017 at 04:13 AM.
hi there. i cant see any leading space in front of your data. a sample excel file would be good. otherwise, try these methods:
1. start from 2nd letter
=MID(A1,2,LEN(A1))
2. find out what is the space. i suspect it could be line spaces (char 10) or non-breaking spaces (char 160).
=CODE(LEFT(A1))
change it by using SUBSTITUTE:
=SUBSTITUTE(A1,CHAR(10),"")
or:
copy the code from the 1st formula. press CTRL + H to find and replace. paste that in Find. Replace with nothing
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Actually it seems they've evilly inserted asterisks randomly. Thankfully tho I've found I can
d/l the data into a csv file so I won't tear my hair over this one - thanks for your help anyhoo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks