Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: help finding a formula for excell cell break down.

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need a formula that breaks one cell down into three cells. On 3-13 I received a reply to a post that gave me the following.
    cell I, = K L M
    15.0 = 8.0, 4.0, 3.0
    8.5 = 8.0, 0.5, False
    8.0 = 8.0, Blank, False
    0.0 = 0.0, Blank, False

    What im looking for is is to break down cell I,into K, L,& M, as follows:

    cell I K, L, M
    15.0 = 8.0, 4.0, 3.0
    8.5 = 8.0, 0.5, 0.0
    8.0 = 8.0, 0.0, 0.0,(Or 0 = BLANK)
    0.0 = 0.0, 0.0, 0.0
    This is used to track time into deferent pay scales I = Total hours into, K = Reg.hours, L = Over time and M = Double time.

    HELPPPPPP! MY 5LB HAMMER IS ABOUT YO DO COMPUTER VIOLANCE, TRYING TO FIGURE THIS ONE OUT. BOB.

    [ This Message was edited by: cblincoln43 on 2002-03-15 11:22 ]

    [ This Message was edited by: cblincoln43 on 2002-03-15 11:27 ]

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have to try and help a man with a Hammer

    What do you have in I?
    Is it just the 15 or 15.0 = 8.0 4.0 3.0?

  3. #3
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It's fairly easy to get the data in two columns (drop the = sign and assume it) or get it into 5 columns.

    Slect your data, click data (menu), text to columns....Click next. Either check space for 5 columns or check "other" and enter an = sign for 2 columns.

    If you separate all values to their own columns (5), it'll be a lot easier to work with the data (e.g. =if(d1="Blank",0,d1)). Hope this helps.

    _________________
    Cheers, NateO

    [ This Message was edited by: NateO on 2002-03-15 11:30 ]

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A range from 0.1 to say 20.1

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    NatoO, I, would like to keep the columns open for use in other cells in a deferant catgories of info. in the same column.

  6. #6
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not exactly sure I follow, but you can sperate the data by "=" as your delimeter. Then insert a column and fill it with = signs. Then it's in three columns as you originally asked. Also, all of this is macro recordable.

    Also, there are 256 columns on a spreadsheet, 2 extra probably wouldn't hurt. Food for thought, you're the boss.

    Hope this helps.

    _________________
    Cheers, NateO

    [ This Message was edited by: NateO on 2002-03-15 12:30 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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