# Split and combine name

Solved/Closed
Related:

- Split and combine name
- Combine notifications viber - Guide
- Lg tv split screen - Guide
- Combine split files linux - Guide
- Combine pdf windows - Guide
- Halo infinite split screen - Guide

## 3 responses

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Feb 5, 2011 at 06:22 AM

Feb 5, 2011 at 06:22 AM

formula in A2 will be

=LEFT(A1,SEARCH("and",A1)-1)

formula lin A3 will be

=RIGHT(A1,LEN(A1)-SEARCH("and",A1)-3)

you can copy the formula along the rows

=LEFT(A1,SEARCH("and",A1)-1)

formula lin A3 will be

=RIGHT(A1,LEN(A1)-SEARCH("and",A1)-3)

you can copy the formula along the rows

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Feb 5, 2011 at 10:13 PM

Feb 5, 2011 at 10:13 PM

NOT CLEAR

they are not split. they are in the same column increase the width of A and see

they are not split. they are in the same column increase the width of A and see

-----------A1-------------------------------------:----------B1-------------------------:------C1

James X. Brian and Timothy F. Brian--:-- James X. and Timothy F -- : --- Brian

column A1 need to split into column B1 (first name and initial only--> James X. and Timothy F.) and column C1(Last name only -->Brian)

Thanks for your help.

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Feb 6, 2011 at 08:16 PM

Feb 6, 2011 at 08:16 PM

see this url

https://www.mrexcel.com/archive/general/finding-last-occurrence-of-character-in-string/

in C1 type this formula (yes first in C1)

=RIGHT(A1,LEN(A1)-SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

in B1 type or copy paste this formula

=LEFT(A1,LEN(A1)-LEN(C1)-1)

you can copy the formulas down.

https://www.mrexcel.com/archive/general/finding-last-occurrence-of-character-in-string/

in C1 type this formula (yes first in C1)

=RIGHT(A1,LEN(A1)-SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

in B1 type or copy paste this formula

=LEFT(A1,LEN(A1)-LEN(C1)-1)

you can copy the formulas down.

Feb 5, 2011 at 08:56 AM

thank you so much for the formula, i saw the 2 name got split into separate column

(James X. Brian and Timothy F. Brian <---> James X. Brian <----> Timothy F. Brian)

could you let me know if is possible to make all the first and middle initial into same column ?

Ex.:

A1 First name Last name

James X. Brian and Timothy F. Brian James X. and Timothy F. Brian

Thank you so very much for your help.

Feb 5, 2011 at 08:59 AM

James X. Brian and Timothy F. <--> Brian James X. and Timothy F.<--> Brian