Formula to show the text between the quotations marks

[Im_Offset]

Hello all my Excellent Excel Educational Experts!

I need your help once again.

I have a row of formulas. The row is 255 columns long. There is a formula in each column that is used to retrieve information from a database. An example formula looks like =RDInfo(A$2,"BaseCode")

Underneath each of those formulas, I want to display the text between the quotation marks " ". So in the example above, I want the cell below the formula to display BaseCode

Can someone tell me a formula that can do that? I don't want to have to go into each formula individually and copy and paste the text manually.

Thank you.

As always...
Im_Offset

 

[Villalobos]

Hi,

Is this help for you?

 

[Im_Offset]

Hi,

Is this help for you?

not quite...I didn't do a proper job explaining.
Here is a spreadsheet to help show what I am trying to do.

Row 2 has the formulas in it. I'm sure there is some error showing in each of the cells now because you do not have the add in I'm using to get the data feed. But you should be able to see the formulas I have typed in each cell from B2:M2

In row 4 I have manually typed the result I am looking for.

Is there a formula that I can type in B3:M3 that will evaluate the formula in B2:M2 and output the text that is between the " " in the evaluated formula (i.e. what I have typed in row 4)???

Thanks

 

[Chihiro]

AFAIK, you can't accomplish it with formula alone. Since all text functions and formula deals with output (values) and not with formula in cells.

One way to do it is to Search & Replace "=" with something like "text="

Then use formula in B3 to extract. Copy and paste over as value.

Finally replace "text=" with "=".

Otherwise you'd need VBA.

See attached for example formula in B3 after Search & Replace.

 

[NARAYANK991]

Hi ,

Depending on your version of Excel , you might be able to do it :

http://www.contextures.com/excelformulatextfunction.html

Narayan