| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Spaces from string
I want to be able to remove spaces from a string, that may have muiltiple words to create a string with no spaces. For example "sin city" to become "sincity" The strings will be of a random length and may contain more than 2 words such as "master & commander" Thanks -- katmando ------------------------------------------------------------------------ katmando's Profile: http://www.excelforum.com/member.php...o&userid=29803 View this thread: http://www.excelforum.com/showthread...hreadid=542452 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing 2 extra spaces in front of dates in imported excel doc | Excel Discussion (Misc queries) | |||
| removing spaces between the numbers | Excel Discussion (Misc queries) | |||
| Removing spaces in cells with data in it | Excel Discussion (Misc queries) | |||
| how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
| Removing trailing spaces from cells ? | Excel Worksheet Functions | |||
Threaded Mode
