+ Reply to Thread
Results 1 to 6 of 6

Extracting from 1 cell and placing extractions in multiple cells

Hybrid View

  1. #1
    Registered User
    Join Date
    11-13-2003
    Posts
    11

    Extracting from 1 cell and placing extractions in multiple cells

    I receive the following data in a (3) cells:

    SYS DESKTOP PIII 500 6.4 G 128M 40X 1.44(1 cell) DELL(1 cell) OPTIPLEX GX1(1 cell)

    Is there any code or command that would extract and put in multiple cells:

    Dell Optiplex GX1 (one cell) DESKTOP (1 cell) PIII500 (one cell) 128MB (one cell) 6.4 G (one cell) 40X (one cell)
    The RAM (128MB) can be anywhere from 32MB-512MB
    The HDD (6.4 G) can be from 1.2-20.4 G

    I receive in 100 computers from a company and it takes me an hour (at least) to type in this stuff manually.

    Your help would be appreciated. Thank you.

    Larry

  2. #2
    Dave Peterson
    Guest

    Re: Extracting from 1 cell and placing extractions in multiple cells

    You have one suggestion in .programming.

    lkw441 wrote:
    >
    > I receive the following data in a (3) cells:
    >
    > SYS DESKTOP PIII 500 6.4 G 128M 40X 1.44(1 cell) DELL(1 cell) OPTIPLEX
    > GX1(1 cell)
    >
    > Is there any code or command that would extract and put in multiple
    > cells:
    >
    > Dell Optiplex GX1 (one cell) DESKTOP (1 cell) PIII500 (one cell)
    > 128MB (one cell) 6.4 G (one cell) 40X (one cell)
    > The RAM (128MB) can be anywhere from 32MB-512MB
    > The HDD (6.4 G) can be from 1.2-20.4 G
    >
    > I receive in 100 computers from a company and it takes me an hour (at
    > least) to type in this stuff manually.
    >
    > Your help would be appreciated. Thank you.
    >
    > Larry
    >
    > --
    > lkw441
    > ------------------------------------------------------------------------
    > lkw441's Profile: http://www.excelforum.com/member.php...fo&userid=2622
    > View this thread: http://www.excelforum.com/showthread...hreadid=387845


    --

    Dave Peterson

  3. #3
    Earl Kiosterud
    Guest

    Re: Extracting from 1 cell and placing extractions in multiple cells

    Larry,

    Dave's post is a nice way of saying please don't post the same question in
    more than one group. It can cause responders to spend time on an answer or
    solution that's already been done.
    --
    Earl Kiosterud
    www.smokeylake.com

    "lkw441" <lkw441.1sbn2a_1121616300.8998@excelforum-nospam.com> wrote in
    message news:lkw441.1sbn2a_1121616300.8998@excelforum-nospam.com...
    >
    > I receive the following data in a (3) cells:
    >
    > SYS DESKTOP PIII 500 6.4 G 128M 40X 1.44(1 cell) DELL(1 cell) OPTIPLEX
    > GX1(1 cell)
    >
    > Is there any code or command that would extract and put in multiple
    > cells:
    >
    > Dell Optiplex GX1 (one cell) DESKTOP (1 cell) PIII500 (one cell)
    > 128MB (one cell) 6.4 G (one cell) 40X (one cell)
    > The RAM (128MB) can be anywhere from 32MB-512MB
    > The HDD (6.4 G) can be from 1.2-20.4 G
    >
    > I receive in 100 computers from a company and it takes me an hour (at
    > least) to type in this stuff manually.
    >
    > Your help would be appreciated. Thank you.
    >
    > Larry
    >
    >
    > --
    > lkw441
    > ------------------------------------------------------------------------
    > lkw441's Profile:
    > http://www.excelforum.com/member.php...fo&userid=2622
    > View this thread: http://www.excelforum.com/showthread...hreadid=387845
    >




  4. #4
    Registered User
    Join Date
    11-13-2003
    Posts
    11

    How do I delete a post?

    If someone can tell me how to delete in another forum, I'd be more than happy to remove a thread.

  5. #5
    Dave Peterson
    Guest

    Re: Extracting from 1 cell and placing extractions in multiple cells

    I don't use excelformum.com, but once you post to a newsgroup, it's too late.
    That's the nature of how messages are distributed between different news
    servers.


    lkw441 wrote:
    >
    > If someone can tell me how to delete in another forum, I'd be more than
    > happy to remove a thread.
    >
    > --
    > lkw441
    > ------------------------------------------------------------------------
    > lkw441's Profile: http://www.excelforum.com/member.php...fo&userid=2622
    > View this thread: http://www.excelforum.com/showthread...hreadid=387845


    --

    Dave Peterson

  6. #6
    Earl Kiosterud
    Guest

    Re: Extracting from 1 cell and placing extractions in multiple cells

    Larry,

    Back when Outlook Express had a command to remove a post, the Microsoft news
    servers wouldn't do it. Now the command seems to be gone (OE 6). Don't
    worry about it. I just point out multiposts from time to time for
    everyone's benefit.
    --
    Earl Kiosterud
    www.smokeylake.com

    "lkw441" <lkw441.1sc0ya_1121634300.9654@excelforum-nospam.com> wrote in
    message news:lkw441.1sc0ya_1121634300.9654@excelforum-nospam.com...
    >
    > If someone can tell me how to delete in another forum, I'd be more than
    > happy to remove a thread.
    >
    >
    > --
    > lkw441
    > ------------------------------------------------------------------------
    > lkw441's Profile:
    > http://www.excelforum.com/member.php...fo&userid=2622
    > View this thread: http://www.excelforum.com/showthread...hreadid=387845
    >





+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1