Parsing part of an address
hi
see if this will work for you....
=IF(ISERROR(SEARCH("#",E8)),"",RIGHT(E8,LEN(E8)-SEARCH("#",E8)+1))
work on all of your examples
regards
FSt1
"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
|