+ Reply to Thread
Results 1 to 4 of 4

how to seperate a combined data into their individual values and place them on another cel

  1. #1
    Registered User
    Join Date
    12-14-2013
    Location
    edo,nigeria
    MS-Off Ver
    Excel 2007
    Posts
    85

    how to seperate a combined data into their individual values and place them on another cel

    hello fellas, thanks for reading my post.
    I normally import .txt files into excel sheet and I would like a formula that will seperate them into three different values as demonstrated in the workbook i attached below.
    these are the rules to seperate them:

    ones seperated with three dots

    20.5023.5020 =20 5023 5020
    34.4543.4544= 34 4543 4544
    100.2.5= 100 2 5

    but ones with four dots

    233.25.65.66= 233.25 65 66
    4.5.56.9= 4.5 56 9


    Waiting for your response,
    Thank you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-14-2013
    Location
    edo,nigeria
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: how to seperate a combined data into their individual values and place them on another

    Still waiting
    Thanks

  3. #3
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: how to seperate a combined data into their individual values and place them on another

    Good time of day.

    You may use formulas from attachment. This is single cell Array Formulas, different for each column. Must be entered with "Ctrl + Shift + Enter" and prolonged down manually.

    What do you think?

    Best wishes.
    Attached Files Attached Files
    Last edited by Rioran; 09-29-2014 at 07:13 AM. Reason: Grammar

  4. #4
    Registered User
    Join Date
    12-14-2013
    Location
    edo,nigeria
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: how to seperate a combined data into their individual values and place them on another

    @Rioran, You just got it perfect!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2003 Macro - Split data in two worksheets and place in a individual workbook
    By Isabelle Whyte in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2014, 04:30 AM
  2. seperate data into individual rows.
    By BillyPapa in forum Excel General
    Replies: 4
    Last Post: 05-19-2009, 02:39 AM
  3. Macro to pull specific data out and place in a seperate worksheet
    By dandavis1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2008, 04:02 AM
  4. Seperate cell string into individual cells
    By ERudy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2006, 02:50 AM
  5. how do I seperate #/#/# in individual # in excel?
    By Andre in forum Excel General
    Replies: 1
    Last Post: 01-27-2005, 06:06 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1