[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

EXCEL 2007

Hi is there a way to split a name in Excel 2007. so happy exchange i need in one cell happy and exchange in another cell in excel.

0
happyexchange
Asked:
happyexchange
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Find the first name in a string:

   =LEFT(A1,FIND(" ",A1)-1)

Find the last name in a string containing only two names:

   =MID(A1,FIND(" ",A1)+1,999)

Kevin
0
 
barry houdiniCommented:
If you have that data in A1 then you can get the first word in B1 with this formula

=LEFT(A1,FIND(" ",A1)-1)

and in C1

=REPLACE(A1,1,FIND(" ",A1),"")

regards,barry
0
 
pjaguilarCommented:
To extract the "happy" part:

=left(B6;find(" ";B6))    // assuming B6 contains "happy exchange"

to extract the "exchange" part:

=right(B6;lenght(B6) - lenght(C6))   // in B6 we had "happy exchange", in C6, the first formula

Regards
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now