Forum Discussion

mesmrc's avatar
mesmrc
Copper Contributor
Dec 08, 2020
Solved

Conditional Name-Copying Formula

I have a column of names that contains some cells that are just first name, and others that are first, last, and middle, all in one cell.   I'd like to have an adjacent column copy just the first n...
excel
Formulas and Functions
  • tauqeeracma's avatar
    tauqeeracma
    Dec 08, 2020

    mesmrc Hi

     

    Try below formula adjecant to main column:

     

    =PROPER(IFERROR(IF(FIND(" ",A2,1)>0,LEFT(A2,FIND(" ",A2,1)-1),0),A2))

    A sample file is also attached for your reference, hoipe it will help.

    Please let me know if it works for you.

     

    Thanks

    Tauqeer

     

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Dec 08, 2020

mesmrc Hi

 

Try below formula adjecant to main column:

 

=PROPER(IFERROR(IF(FIND(" ",A2,1)>0,LEFT(A2,FIND(" ",A2,1)-1),0),A2))

A sample file is also attached for your reference, hoipe it will help.

Please let me know if it works for you.

 

Thanks

Tauqeer

 

  • mesmrc's avatar
    mesmrc
    Copper Contributor
    Dec 08, 2020

    tauqeeracma amazing thank you so much! Works perfectly :hundred_points:

Resources