Hi Night Owl

Doubtless there are better ways, but if the address is in A2, enter the
following in B2 and copy down.

=IF(ISERROR(FIND(",",LEFT(A2,5),1)),A2,TRIM(RIGHT( A2,LEN(A2)-FIND(",",LEFT(A2,5),1))))

--


XL2003
Regards

William



"Night Owl" wrote in message
...
I have a long list of addresses, some of which start with a house number
then a comma. Is there a (simple) way of finding the position of the comma
within the first (say) 5 characters of the string, and, if it exists,
remove everything to the left of and including the comma, leaving the rest
of the text string?

Thanks in advance,

Pete