Results 1 to 10 of 18

Thread: Extract numbers from text into multiple columns

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Sep 2015
    Posts
    10
    Rep Power
    0
    sorry to clarify, the data in columns A & B from message 10 are the actual data. the other columns are what happened when i ran the code in the file, it filled columns C to F. so only A & B columns are the actual data i have to start with.

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by Giraffe View Post
    sorry to clarify, the data in columns A & B from message 10 are the actual data. the other columns are what happened when i ran the code in the file, it filled columns C to F. so only A & B columns are the actual data i have to start with.
    Sorry, but that did not clarify anything for me... Message #10 is my message and has two different tables in it with two different problems. I think it best if we hit the reset button and start over. Show me two tables... the first table should show me a sample of your actual data (which I think you are now saying is only two columns wide) and then show me a second table with the results you want to see derived from that same sample data. Once I see them (real data... real results you want from it), I think I will be in a better position to proceed. Whatever you do, do not try to explain or clarify what has been posted earlier... start over like this was your first message and be careful about the accuracy of the existing data you show us and about the accuracy of what you want from that existing data.

Similar Threads

  1. Extract Only Numbers & TEXT From Text String
    By mahmoud-lee in forum Excel Help
    Replies: 9
    Last Post: 11-02-2013, 02:49 PM
  2. Replies: 4
    Last Post: 05-01-2013, 09:49 PM
  3. Replies: 2
    Last Post: 09-24-2012, 09:20 PM
  4. Extract numbers from alphanumeric values
    By tushar.tarafdar in forum Excel Help
    Replies: 3
    Last Post: 09-20-2012, 10:16 PM
  5. VBA Function To Extract Decimal Numbers
    By PcMax in forum Excel Help
    Replies: 7
    Last Post: 11-19-2011, 09:42 PM

Tags for this Thread

Posting Permissions

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