extract cell value

  1. B

    Extract text string from a larger text string

    Hi everybody, I am working on a problem for which I have been unable to find a good answer out on the web. I would like to pull nine-digit strings from a string of text that is not uniform in size, content, or data arrangement. The only constant is that the string is always nine digits long...
    • bbull
    • Thread
    • excel extract cell value find text string
    • Replies: 3
    • Forum: Excel Questions
  2. B

    Extracting numbers from a text string to use in a calculation

    I am trying to extract numbers, some of which are fractions, from a text string to use in calculating the weight of the material in a list. Example from cell D14: Bar 4x1/4 I was able to extract the "4" with =VALUE(MID(D14,SEARCH(" ",D14,1)+1,(SEARCH("X",D14,1))-(SEARCH(" ",D14,1)+1))) but I...
    • bigalrm1
    • Thread
    • convert text to numbers extract cell value text and numbers
    • Replies: 8
    • Forum: Excel Questions
  3. P

    Converting Date to Time --- Please Help!

    I used the function: MRound(Cells(i, 1).Value, 1 / 24), to round each of my dates to the nearest hour. I now have cells that look like the following: (1/1/2014 12:00:00 AM), (1/1/2014 1:00:00 AM), (1/1/2014 2:00:00 AM)..... ETC. How do I write a program that extracts JUST THE HOUR. SO for...
  4. A

    VBA to extract data from block info in a long row,and copy on another sheet non adjacent column

    Hi all, I know a lil bit excel, and i just started to learn VBA, need some help on creating this report. In a worksheet "Hist" i have a 36 block of data located in a single row, each block use 12 column of data block 1 = F4:Q4, (3 blanc column) then Block 2 = U4:AF4, then (3 blanc column) and...
    • AndyJR
    • Thread
    • extract cell value non adjacent cell report
    • Replies: 10
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top