var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help needed separating data
Is there some coding that will help me separate some data I'm working on.
Within a field titled 'Customer Surname' there is a reference of either AM or SM after the surname.
I.e. Smith SM
How do I separate the data so that I have the surname in one field and the reference in the next?
If you're only dealing with "AM" and "SM" I would suggest to get the surname.
To get the reference of "AM" or "SM" and if it's always at the end, then =Right(A1,2)
Excellent, thanks for your help!
Or if that is exactly how all the cells are, you can use Data > Text to Column, and choose "space" as the separator.
Hey there Shades,
Originally Posted by shades
Wow, I just tried the Text to Column you suggested with the Comma delimiter and man was that awesome. Great tip.
Indeed, it saves considerable time, and avoids unnecessary formulas!