Split and combine name
Solved/Closed
Related:
- Split and combine name
- Combine notifications viber - Guide
- Combine social media feeds - Guide
- Linux split - Guide
- Instagram split photo - Guide
- Split excel sheet into multiple files - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
5 Feb 2011 à 06:22
5 Feb 2011 à 06:22
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 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
5 Feb 2011 à 22:13
5 Feb 2011 à 22:13
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
Sorry for the confusion. :)
-----------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.
-----------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 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
6 Feb 2011 à 20:16
6 Feb 2011 à 20:16
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.
5 Feb 2011 à 08:56
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.
5 Feb 2011 à 08:59
James X. Brian and Timothy F. <--> Brian James X. and Timothy F.<--> Brian