| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parsing part of an address
Thank you. I was not sure of where to post it and will be more careful in
the future. "Pete_UK" wrote: You have replies elsewhere - please do not multipost. Pete On Nov 12, 11:54 pm, LSSR wrote: I have excel 2003 and XP. I have a worksheet with some 50,000 entries. Column E is an address field. Some 7,000 of the addresses have a suite number in the format of 123 Main St # A 456 Elm St 789 Oak Ave # 44 I need to take delete the space to the left and to the right of the # and place the value (the A and the 44 above example) into column F. Is there a formula that I can paste and fill in column E (and if so, would not return an error code in column F if the row in column E does not have a # )? My skills are very, very basic and I do not know VBA . thank you for your time |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another Parsing address question | Excel Discussion (Misc queries) | |||
| parsing out an undelimited address and city | Excel Discussion (Misc queries) | |||
| parsing out an undelimited address and city | Excel Discussion (Misc queries) | |||
| VLOOKUP with cell address as part of the argument | Excel Discussion (Misc queries) | |||
| Parsing address info | Excel Discussion (Misc queries) | |||
Threaded Mode
