Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
left trim
Hello, I need a query that will left trim everything after the first comma in
a string. Example 1 Airport Boulevard, Gentry, AR 72734 I need just the street address to remain. Also some of the cells in the column are blank, some cells have only the city and state. Also need to know hoe the run it and from where. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
Trim | Excel Worksheet Functions | |||
Trim | Excel Discussion (Misc queries) | |||
How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
trim | Excel Worksheet Functions |