+ Reply to Thread
Results 1 to 6 of 6

Extract Numbers to new column

Hybrid View

  1. #1
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Extract Numbers to new column

    How do the numbers 13 and 15 appear on a cell? Do they appear as 1315, or 13 in one cell and 15 in the next cell?

  2. #2
    Registered User
    Join Date
    08-23-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Extract Numbers to new column

    Yes they should be in a single column....keeping in mind there can be numbers 01-18 in a cell so they need to come out and be dumped in a column so I can do a count of them.

    13
    15

    Unless I had a macro to search for all occurrences of numbers and count them, this will have to do for now.

    Thanks,
    Sam

  3. #3
    Registered User
    Join Date
    11-27-2012
    Location
    Plattsburgh
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Extract Numbers to new column

    I haven't done this in years and I forgot....

    Cell A1 is populates with the following information 100-51040-360-000. I would like to create four different cells so that the information appears respectively in each cell: Cell B1 100; C1 51040; D1 360; E1 000.

    I know this is simple, but it's Friday and my brain has shut down.

    Thanks!

+ 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