Replace values in cell

[Oleg]

Hello!

It is possible to replace values in cell.
For example I have Name Surname entered in cell A1
I'd like to rearrange this two values separated with space.(Result Surname Name)

Thanks.

[JBeaucaire]

If the name is in cell A1, use this formula:

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

Now copy down as far as needed.

[Oleg]

Thank you .