Split and combine name
Solved/Closed
Related:
- Split and combine name
- Combine notifications viber - Guide
- How to split pictures on instagram - Guide
- Linux split file - Guide
- Combine ethernet tethered iphone windows - Guide
- Split table in word - 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
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 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