Results 1 to 6 of 6

Macro to split words

Threaded View

  1. 12-01-2009, 05:08 AM #1
    Lana75
    Lana75 is offline
    Registered User
    Join Date
    12-01-2009
    Location
    Paris, France
    MS-Off Ver
    Excel 2003
    Posts
    5

    Wink 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?
    Last edited by Lana75; 12-01-2009 at 06:31 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1