Formula to remove every middle name in a cell in Excel

0 votes
Hello, I'm attempting to delete every individual's second and/or third name from my excel spreadsheet. I'm currently doing it manually, which is really boring. Exists a formula that executes it automatically?

Is it feasible to change the text in cell A1 from "Filippo Luigi Carlo" to just "Filippo" as an example?

In an excel file, remove every second and third name (if the person has them) from each cell.
Jan 19 in Others by Kithuzzz
• 27,740 points
28 views

1 answer to this question.

0 votes

Use this:

=IFERROR(LEFT(A1,FIND(" ",A1)-1),A1)

What does it do?

  1. Finds the first space in your target text FIND(" ", A1)
  2. Takes all the characters from the start of your target text up until the spot before the first space LEFT(A1, {step 1} - 1)
  3. If there is an error (for example there is no space in your target text), it will simply return the original target text =IFERROR({step 2}, A1)
answered Jan 19 by narikkadan
• 51,240 points

Related Questions In Others

0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 27,740 points
60 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9 in Others by narikkadan
• 51,240 points
32 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 51,240 points
1,070 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 51,240 points
71 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
205 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
364 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,640 points
165 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
144 views
0 votes
1 answer

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 51,240 points
156 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP