Hi,
Please let me know how to remove extra space from the text with in a cell.
I have already used trim function but that is not working.
Hi,
Please let me know how to remove extra space from the text with in a cell.
I have already used trim function but that is not working.
There could be other invisible characters but try this formula
assuming text in cell A1
=TRIM(SUBSTITUTE(A1,CHAR(160),""))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks