Hi guysa
I have some text in column where there are spaces before the text
I have tried using mid, trim functions
It's not giving me the desired output and it is affecting lookups I want to do. If you see my sheet the text in cells a1 to a12 seem fine, it is a13 - a35 as an example that is where the text becomes a bit funny with spaces i want to remove
thank you fro your help
Thanks,
R.
Removed by author
Last edited by Pepe Le Mokko; 08-25-2022 at 03:05 AM.
Rayted is in the UK, so the formula will need commas:
=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))
I would also change the final argument:
=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160),"")))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Haha - Dirty data sounds right!
Thank you both and thasnk you Ali - the 2nd of your formulas worked a charm!
Happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks