I have a column with the first and last name separated by a comma.
I want just the last name i.e.
Jobs, Steve
I need this
Jobs
I have 1500 names and addresses to go through.
I there a way to eliminate the comma and first name?
MacBook Air, iOS 7.0.3
Hi Chris,
Formula in B2 (and Fill Down)
=FIND(",",A2)
Formula in C2 (and Fill Down)
=LEFT(A2,B2−1)
Combine those two formulas into a single formula (or hide Column B 😉).
Regards,
Ian.
Hi Chris,
Formula in B2 (and Fill Down)
=FIND(",",A2)
Formula in C2 (and Fill Down)
=LEFT(A2,B2−1)
Combine those two formulas into a single formula (or hide Column B 😉).
Regards,
Ian.
Ian, This is perfect. I am not well versed in numbers. Thank you for you help 🙂
Where do I put the formula? Are you tell me to put the
Formula in B2? How do I Fill down? (and Fill Down)
=FIND(",",A2)
Formula in C2 (and Fill Down)
=LEFT(A2,B2−1)
How would I combine the two formulas
Combine those two formulas into a single formula (or hide Column B 😉)
Ian, I think I go this. Man!! I can't thank you enough for the quick response. Very cool of you to help me.
Thank you
Chris
Hi Chris,
Looks like Ian has you sorted.
After you get your result column you can copy/paste formula results to keep the last name indipendently of the other columns. Your formula would be gone only the results remain.
quinn
T Quinn,
I need this step now because when I do move (Copy/paste) the new column with the single last name.
I get the error triangle. How can I keep the result without the formula?
Hi Chris,
Select the column containing the first names (C in Ian's example).
Copy.
With the column still selected, choose Paste Results (or Paste Values, depending on the version of Numbers in use).
Regards,
Barry
Thank you Barry. Thank you everyone this is a list I was going to have to go down 1500 names and delete a comma and first name.
Thank you so my folks
deleting a portion of content within a column
