I don't think I've got this HTML maker thing right yet.
Following on from the help I received yesterday,I would now like to extract the value to the right of the cells containing Cd.
I can get 57.0, but I don't know how to get rid of the comma following the value. You will see that the values aren't always four characters in length. ie. 54 - 55 - 52.5.
Again, the values aren't always in the same column.
Any suggestions will be much appreciated.
F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
E1 =
A B C D E
1 5, Cd 57.0, (53.5), 57.0,
2 8, Cd 54 -1.5,
3 Cd 55 -3.0, (54.5),
4 6, Cd 52.5 -0.5,
Sheet1
Following on from the help I received yesterday,I would now like to extract the value to the right of the cells containing Cd.
I can get 57.0, but I don't know how to get rid of the comma following the value. You will see that the values aren't always four characters in length. ie. 54 - 55 - 52.5.
Again, the values aren't always in the same column.
Any suggestions will be much appreciated.
F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
E1 =
A B C D E
1 5, Cd 57.0, (53.5), 57.0,
2 8, Cd 54 -1.5,
3 Cd 55 -3.0, (54.5),
4 6, Cd 52.5 -0.5,
Sheet1