Quote:
Originally Posted by juddman
This didn't work.
|
It works for me.
Do note that, as with most Excel formulas posted in forums where no cell address context is given, the formula assumes the data are in A1 and the formula is in any other cell. Obviously, you can't put a formula in the very cell you want to extract data from and, if the cell you want to process isn't A1, you need to change the formula's cell references.