Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've imported a query from an AS400 database, and in the column that I'm
using as my "sort", many of the entries start with a blank space. I can left-justify, but there's still a blank space in some of them, which is messing up my sort. Is there a macro that I can write to eliminate a blank space at the beginning of any cell entry? Additionally, some cells begin with a "<", or a "{" that is unnecessary. I'd like to be able to eliminate those extraneous characters or blank spaces using a macro if possible. Thanks for any help. K- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Extra line space | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
macro to eliminate spaces between words | Excel Discussion (Misc queries) |