Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing space characters
To Whom it may concern,
I am using Excel 2003 to create reports from ISPF *.csv files. Due to the type of dataset I'm using, many of the cells will contain space characters that I will want to delete. For the majority of the report, a simple "Replace" code will work well, but there are some cells that need only the space characters on the left removed. Also, the length of data that needs to be reported varies dramatically. So, how can I format the text in a cell so that all of the spaces within the text remain, and those on the left of the last character are removed? TIA Andrew from Telstra |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Space | Excel Worksheet Functions | |||
Removing Space | Excel Worksheet Functions | |||
Removing Space | Excel Discussion (Misc queries) | |||
Removing a space within a cell | Excel Worksheet Functions | |||
Removing special characters and extra white space | Excel Programming |