Avatar of elliottbenzle

asked on 

Excel - subtract string to create a new column

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?

Microsoft ExcelSpreadsheetsMicrosoft Office

Avatar of undefined
Last Comment
zorvek (Kevin Jones)

8/22/2022 - Mon