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
Jones AM

How do I separate the data so that I have the surname in one field and the reference in the next?

Thanks

Hmmmm...

If you're only dealing with "AM" and "SM" I would suggest to get the surname.

If(Right(A1,2)="AM",LEFT(A1,FIND("AM",A1)-1),if(right(A1,2)="SM",left(a1,FIND("SM",A1)-1)))

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,

Wow, I just tried the Text to Column you suggested with the Comma delimiter and man was that awesome. Great tip.

BUD

Indeed, it saves considerable time, and avoids unnecessary formulas!