Link to home
Start Free TrialLog in
Avatar of kerikeri
kerikeriFlag for New Zealand

asked on

Create a formula to modify the layout of a cell

Original cell has format SURNAME FIRSTNAME SECONDNAME.  I need to a create a formula to create cell with SURNAME at the end of the string, not the beginning.  
Example:
Whiting Jessica Clare needs to become Jessica Clare Whiting
ASKER CERTIFIED SOLUTION
Avatar of [ fanpages ]
[ fanpages ]

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kerikeri

ASKER

perfect!  Thanks for such a prompt response, I'd spent about an hour mucking around then thought of EE.  Wonderful.
Avatar of [ fanpages ]
[ fanpages ]

:)

You're very welcome.