Hello,

Assuming that your address is in cell A1, the formula below should do the
trick.

=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1,"
","")))))
--
Hope this helps,
MarkN


"Jill" wrote:

I have a data sheet with about 3000 entries, each one containing an
address. Only problem is that it was brought in from another program and
when they did it it grouped the City and the street address. So, I have
one cell for each entry that looks like;

123 Easy Street London

all in one cell.

I would like to put London in another cell, so that I can sort by city
without soing each one individually. Any ideas?

thx,

A