Extract text from cells?

Can I extract text from cells... without double-clicking in each cell and copying and pasting?

See attachment.

Thanks,

do you want to keep the same values??

I apologize, I'm not sure exactly what you're asking. I guess the term "value" has thrown me. I'm not sure if "value" is real stuff inside the cell, or the result of the formula.

I want to extract the raw text (formula) from within each cell. If the text (formula) inside a cell is:
=(53+42+55+52+52+54+57+57+56+55+57+51+53+57+46+54+28)/(SUM(Daily!$F$97:$F$113))", then that is exactly what I want to extract out of the cell. The section in red is specificially what I'm after. I need to place those numbers into a database. I'm hoping that there is a more effecient way than double-clicking into each cell, copying & pasting it. I'm needing to extract those numbers from C10:F14. I'm not needing the numbers that the formulas produce. I hope I've explained better than my original post.

Hey, would you mind taking a look another post of mine? I'm seeking feedback at:
http://www.excelforum.com/showthread.php?t=592315

I appreciate your time and willingness to help.

Thanks,
David

Open a new workbook

Place your formula

Please Login or Register  to view this content.

in A1 and then run this code

Please Login or Register  to view this content.

I am not sure about deleteing

)/(SUM(Daily!$F$97:$F$113))
this example will work, but if you have different sized formulas it might not


Maybe somebody can add to this

ActiveCell = Left(ActiveCell, Len(ActiveCell) - 28)
so it will subtract the actual number of text from ")" to")"

Dude! It works!!

Thanks!

It worked grrrreat! and saved me bunches of time!
Thanks!