Split Name Field in Excell

C

crystal

I have a single name field that has both the first and
last name of some clients. How can I separate each name
and create separate fields for each?
 
J

JulieD

Hi crystal

the easiest place to start is by using data / text to columns ...

insert a couple of spare columns to the right of the column you want to
split
select the column to split
choose data / text to columns
ensure delimited is selected - press next
untick tab, tick space
press finish

let us know how you go

Cheers
JulieD
 
R

RagDyeR

Select the column of names, then:

<Data> <Text To Columns> <Next>
Then click in the delimiter that you used.
You can click *both* space and comma if that's what's in the column.
Then <Finish>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a single name field that has both the first and
last name of some clients. How can I separate each name
and create separate fields for each?
 
Top