Karen,

Try this

=MID(A1&" "&A1, FIND(" ",A1)+1,LEN(A1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Karen" wrote:

What is the excel formula to change John Brown to Brown, John? Thanks!