Insert Space Between Initials
 

Hello -

I have an export file that I need to format the name cell in order to import it into another software. Is there a formula that can split the initials in a name? Names have all different lengths for first and last name.

Current Cell:
John MDoe

Needs to be:
John M Doe

Thanks

Answer: Insert Space Between Initials
 

You can use Excel formulas to split the initials in a name and format it to the desired format. Here's how you can do it:

1. Insert a new column next to the name column where you want to split the initials.
2. In the new column, use the formula
   Code:

   ---

   =LEFT(A2,FIND(" ",A2))

   ---

   to extract the first name from the full name.
3. Then, in the next column, use the formula
   Code:

   ---

   =MID(A2,FIND(" ",A2)+1,1)

   ---

   to extract the middle initial.
4. Finally, in the next column, use the formula
   Code:

   ---

   =RIGHT(A2,LEN(A2)-FIND(" ",A2)-1)

   ---

   to extract the last name.
5. Combine the first name, middle initial, and last name into one cell using the formula
   Code:

   ---

   =B2&" "&C2&" "&D2

   ---

   .

You will have a column with the first name, a column with the middle initial, and a column with the last name. You can then combine these columns into one cell to achieve the desired format of the name, with the first name, middle initial, and last name separated by spaces.

Note that in these formulas, A2 refers to the cell containing the full name, and B2, C2, and D2 refer to the cells containing the first name, middle initial, and last name, respectively. Make sure to adjust the cell references in the formulas to match your specific spreadsheet.