In Excel I have two columns with strings, one has a full name and one has a first name. Like this:
column 1 column 2
Christina Swartz Christina
Ms. Jill A. Swedlow Ms. Jill A.
Mr. Ralph (Ed) Sweet Mr. Ralph (Ed)
I want to use some kind of an equation in a third column that will fill that column with only the last name. I don't know excel very well, but I think it would look something like this:
Column C = Column 1 - Column 2
Does anyone know how to do this? or if it's even possible?