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, 2023 in Others by Kithuzzz
• 38,010 points
603 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, 2023 by narikkadan
• 63,720 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
• 38,010 points
258 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, 2023 in Others by narikkadan
• 63,720 points
515 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

answered Feb 6, 2023 in Others by narikkadan
• 63,720 points
723 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
• 63,720 points
3,365 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,670 points
2,566 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,670 points
1,690 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,670 points
833 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
• 23,260 points
3,035 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
• 63,720 points
4,163 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW