[Webinar] Streamline your web hosting managementRegister Today

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

# 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
1 Solution

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

Commented:
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

Commented:
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

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