Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to remove a space after a string?
Hello,
Does anyone know how to remove a space after a string? does excel read 'space' a string? ie: 1.holiday inn(no space) 2.holiday inn(space) 3.holiday inn heathrow(space) is it possible to keep the space been holiday and inn, but remove the space at the end? keeping the space between holiday and inn, inn and heathrow but remove the last space? and do nothing if theres nospace at the end of 1st holiday inn? thanks. Elaine. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to remove a space after a string?
Hi Elaine,
In VBA, sStr = RTrim("holiday inn heathrow ") See also LTrim and Trim in VBA help In Excel, try the Trim worksheet function. --- Regards, Norman "elaine" wrote in message ups.com... Hello, Does anyone know how to remove a space after a string? does excel read 'space' a string? ie: 1.holiday inn(no space) 2.holiday inn(space) 3.holiday inn heathrow(space) is it possible to keep the space been holiday and inn, but remove the space at the end? keeping the space between holiday and inn, inn and heathrow but remove the last space? and do nothing if theres nospace at the end of 1st holiday inn? thanks. Elaine. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to remove a space after a string?
=TRIM(" removes extra spaces at the beginning and end of a string ")
"elaine" wrote: Hello, Does anyone know how to remove a space after a string? does excel read 'space' a string? ie: 1.holiday inn(no space) 2.holiday inn(space) 3.holiday inn heathrow(space) is it possible to keep the space been holiday and inn, but remove the space at the end? keeping the space between holiday and inn, inn and heathrow but remove the last space? and do nothing if theres nospace at the end of 1st holiday inn? thanks. Elaine. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to remove a space after a string?
thank you so much!
very helpful!!! Elaine. Charlie wrote: =TRIM(" removes extra spaces at the beginning and end of a string ") "elaine" wrote: Hello, Does anyone know how to remove a space after a string? does excel read 'space' a string? ie: 1.holiday inn(no space) 2.holiday inn(space) 3.holiday inn heathrow(space) is it possible to keep the space been holiday and inn, but remove the space at the end? keeping the space between holiday and inn, inn and heathrow but remove the last space? and do nothing if theres nospace at the end of 1st holiday inn? thanks. Elaine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove non-space spaces? | Excel Worksheet Functions | |||
remove space BE 039 to BE039 | New Users to Excel | |||
remove space | Excel Worksheet Functions | |||
Remove Space in Cells | New Users to Excel | |||
How to remove a space | Excel Discussion (Misc queries) |