 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Chat Forum
3
Posts
3
Users
0
Reactions
38
Views
Topic starter
I have a column which contains names in the format surname,firstname
I need to change this to firstname.surname
Can't see a text formula for this. Anyone know if there is one or an easy way to do this?
Thanks
Posted : 14/07/2014 9:29 am
You can use the "text to columns" function in the data menu to split the field into firstname and surname then it's easy enough to create what you need?
Posted : 14/07/2014 9:32 am
I haven't got excel on this machine to check but...
=RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) + "." + LEFT(A1, SEARCH(",",A1,1))
or something similar
Posted : 14/07/2014 9:33 am
Topic starter
WackoAK wins the Gold Star
This place is bloody brilliant 😀
Posted : 14/07/2014 9:35 am