Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete spaces from the end of text
Some of the text fields that I have to clean up have a space (or more than
one space). I need to clean this text up so the last word is the end of the text string. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete spaces from the end of text
Id the text copied from the web, in that case you might have trailing html
characters, if not us =TRIM(A1) otherwise =TRIM(SUBSTITUTE(A1,CHAR(160),"")) if there are many see: http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Regards, Peo Sjoblom "George" wrote in message ... Some of the text fields that I have to clean up have a space (or more than one space). I need to clean this text up so the last word is the end of the text string. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete spaces from the end of text
Very helpful. Thanks again.
"Peo Sjoblom" wrote: Id the text copied from the web, in that case you might have trailing html characters, if not us =TRIM(A1) otherwise =TRIM(SUBSTITUTE(A1,CHAR(160),"")) if there are many see: http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Regards, Peo Sjoblom "George" wrote in message ... Some of the text fields that I have to clean up have a space (or more than one space). I need to clean this text up so the last word is the end of the text string. Any ideas? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete spaces from the end of text
Hi, have a look at the TRIM function. Regards JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=493960 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete spaces from the end of text
What if the space appears to be at the front?? I copied some data, and i have to go cell-by-cell and delete out the first space (but there doesnt seem to be a space) to make a formula work that is referring to that cell?? Thanks! Veronica "pinmaster" wrote: Hi, have a look at the TRIM function. Regards JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=493960 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
Macro to delete and replace a text box | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Macro to delete a text box and copy in new one | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |