|
|
|
Breaking Up Text Strings
Taking a full name like "Joe Smith"
and getting "Joe" and "Smith" separated
Q: |
I received a spreadsheet that has a column of full
names like "Joe Smith." I need to break this name up so that I have
"Joe" and "Smith" in two separate columns. What can I do? |
|
|
A: |
There are four functions
in Excel that you can use to accomplish this goal: LEN, FIND, LEFT,
and RIGHT. I'll show you how to do this in the following free video
lesson: |
|
 |
|
|
|
Here is a FREE video tutorial that shows you how to set
this sheet up step-by-step:
|

By Richard Rost
Click here to sign up for more FREE tips
|
Check out these other pages that may be of interest to you: |
|