G
Guest
I have a row (A:BI) with text or numbers in each cell. However, there are
some cells that are blank. B,D,F,H,J,... are the number cells (unless they
are blank) and A,C,E,G,I,K,... are the text cells (unless they are blank).
I would like to have all the cells that have text in them to be entered into
cell A5 and down. Same thing with the number cells except in cell B5 down.
Example:
A B C D E F
1 PHI 2.3 OTT 3.6
I would like the following:
A5 = PHI B5 = 2.3
A6= OTT B6 = 3.6
Anyone know how to do this? Thanks
some cells that are blank. B,D,F,H,J,... are the number cells (unless they
are blank) and A,C,E,G,I,K,... are the text cells (unless they are blank).
I would like to have all the cells that have text in them to be entered into
cell A5 and down. Same thing with the number cells except in cell B5 down.
Example:
A B C D E F
1 PHI 2.3 OTT 3.6
I would like the following:
A5 = PHI B5 = 2.3
A6= OTT B6 = 3.6
Anyone know how to do this? Thanks