| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank spaces
Use the TRIM function to remove spaces at either end of a text string. It will not eliminate spaces between words. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=495534 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank spaces
"SteveG" wrote in
message ... Use the TRIM function to remove spaces at either end of a text string. It will not eliminate spaces between words. .... but it will reduce multiple spaces to a single space. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbered List with Blank Spaces, etc. | Excel Discussion (Misc queries) | |||
| CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH | Excel Worksheet Functions | |||
| CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH | Excel Worksheet Functions | |||
| Blank spaces in a listbox | Excel Discussion (Misc queries) | |||
| "False" filling in the blank spaces | Excel Discussion (Misc queries) | |||
Hybrid Mode
