Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parsing part of an address
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) |