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
|