Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove white spaces in Back
Hi I used =trim(A1) to remove for the front space and it works. Is there a way to remove the back space after the characters in column. -- dziw ------------------------------------------------------------------------ dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422 View this thread: http://www.excelforum.com/showthread...hreadid=562973 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove white spaces in Back
ASAP Utilities, a free Add-in available at www.asap-utilities.com has
features that will do this for you easily.. Vaya con Dios, Chuck, CABGx3 "dziw" wrote: Hi I used =trim(A1) to remove for the front space and it works. Is there a way to remove the back space after the characters in column. -- dziw ------------------------------------------------------------------------ dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422 View this thread: http://www.excelforum.com/showthread...hreadid=562973 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove white spaces in Back
The TRIM function removes leading and trailing spaces but not spaces between
words or separate strings in a cell. Why do you think you still have trailing spaces after using TRIM? Try this in A1......enter 3 spaces then qwerty then 3 more spaces. In B1 enter =LEN(A1) should return 10 In A2 enter =TRIM(A1) In B2 enter =LEN(A2) should return 6 If you are not getting rid of the trailing spaces, perhaps they are HTML non-breaking spaces....CHAR(160) You can try editreplace what: ALT + 0160(from the numpad) with: nothing Replace all. Gord Dibben MS Excel MVP On Wed, 19 Jul 2006 13:29:26 -0400, dziw wrote: Hi I used =trim(A1) to remove for the front space and it works. Is there a way to remove the back space after the characters in column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
Remove spaces phonenumbers | Excel Discussion (Misc queries) | |||
Counting number of forwarding and sending back | Excel Discussion (Misc queries) | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
how do I remove spaces from cells that were pasted | Excel Discussion (Misc queries) |