Suppose you have the following:
smith - xx - john
anderson - xx - april
williams - xx - john
What i want to do is to have it end up like
xx john smith
xx april anderson
xx john williams
You cant use LEFT or MID or RIGHT afaik because of the length of the string.
Anyone have any suggestions on how to accomplish this?
The string would be in A1, A2, etc.