Solved

EXCEL 2007

Posted on 2011-03-17
3
188 Views
Last Modified: 2012-05-11
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
Comment
Question by:happyexchange
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35160672
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
 
LVL 50

Expert Comment

by:barry houdini
ID: 35160673
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
 
LVL 2

Accepted Solution

by:
pjaguilar earned 500 total points
ID: 35160725
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question