Macro: Split Name cells around spaces

[mossbs]

Hi All,

First off - Macros in Excel are certainly is not a strong point of mine, so bare with me!

Right i have an excel s/s with 2 columns....
name and email address

What i need to do is split the name column into 3 columns as it contains 3 sets of data...

Title: Mr
FirstName: Jim
LastName: Morrison

So at present the name column looks like 'Mr Jim Morrison'

Is there any way to split this column into 3 using the 'space' as the delimiter?

Cheers for any help.

Dan.

 

[SkipVought]

Hi,

I'm keeping everything in place on my person, thank you.

Insert 2 or 3 columns BETWEEN your two columns.

Select the NAME column so you can parse, using the space delimiter.

Data > Text to columns -- DELIMITED: Select SPACE --FINISH

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[mossbs]

hmmmmmm...twas somewhat simpler than i imagined eh!?!
d'oh!

awesome though cheers for the help dude!

 

[xlbo]

Just be careful that you do have the 3 pieces of data for each record though - normally with this kind of thing, the trickiness comes in having to deal with lack of Mr / Mrs or a middle name or a double barrel surname - all of these things can throw text to columns out of whack.

If you've got nice neat data however, then definitely the best way for a one off job

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Ahhhh, the voice of experience!

Take heed of Goeff's sage advise, not to mention parsley, rosemary & thyme.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[mossbs]

i'm more of a basil man myself... but still sound advice!

cheers all!