Macro to split words

Hi Guys,

I have a excel sheet that contains about 8000 entries... I need to create a macro to help me.

my file is like this:

123
RT4
eliott.billy
mark.garth
elena.david

I would like to split first name and last name. All the ligne that contains "." split it in 2.

Example
eliott.billy will become eliott (column A) billy (column B)

Does anyone have any idea?

Select the column
Click Data - Text to columns
Select delimited, then "next"
Select the . symbol as the delimiter
click Finished

Hi Lana75,

Welcome to the forum.

You don't need a macro to do this. See if the following five steps do the trick:

1. Highlight the data in question
2. From the Data menu select Text to Columns
3. Ensure the Delimited radio button is selected and then click Next
4. Click the Other check box and enter "." into its text box
5. Ensure there are no other delimiters selected and then click Finish

HTH

Robert

Re: Text to Columns -> once complete it's worth repeating the process simply to turn off the period delimiter by un-checking it... if you don't you run the risk of some odd results copying/pasting numbers in your current XL session
(ie XL will try to be helpful and "remember" your "preferred" delimiter whenever you paste values)

or maybe

Please Login or Register  to view this content.