lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hello
I just like to pick your brain. I have a column which has the firstname and lastname (one space between them). I want a new column which has the "lastname, firstname". One way I am thinking of is to use Text-to-Columns to separate the firstname from the lastname, then I will use =Concatenate(lastname,",",",firstname). Is that the only way? Do you have other ideas to do the same? Thank you so much.
<tbody>
</tbody>
I just like to pick your brain. I have a column which has the firstname and lastname (one space between them). I want a new column which has the "lastname, firstname". One way I am thinking of is to use Text-to-Columns to separate the firstname from the lastname, then I will use =Concatenate(lastname,",",",firstname). Is that the only way? Do you have other ideas to do the same? Thank you so much.
right now | what i want |
John Smith | Smith, John |
Mary Clark | Clark, Mary |
Adam Jones | Jones, Adam |
<tbody>
</tbody>