Select some of cell content
Posted: Wed Dec 07, 2011 9:36 am
Hi there,
I wonder if there is a way to get some of the information from cell content when we collecting data from tables?
To explain, I need to get result from cointegration test result table which says " Trace test indicates no cointegration at the 0.05 level" or " Trace test indicates 1 cointegrating eqn(s) at the 0.05 level". this message is in one cell, I need to collect only the number "1" or "no" from the cell not all the message.
Please advise me.
Regards
Daniel
I wonder if there is a way to get some of the information from cell content when we collecting data from tables?
To explain, I need to get result from cointegration test result table which says " Trace test indicates no cointegration at the 0.05 level" or " Trace test indicates 1 cointegrating eqn(s) at the 0.05 level". this message is in one cell, I need to collect only the number "1" or "no" from the cell not all the message.
Please advise me.
Regards
Daniel