Hi Paul
I still need your help
.
If I type the data for the formula to work on the formula works fine. However if I copy the data from a "Text" file into Excel the formula does not work.
The data is pasted with a cell format as "General".
I have tried marking the column as "Text" prior to pasting the data but it still does not work.
I am getting #VALUE error which I know is conflicting data types but the data is in one cell!
Any help would be appreciated.
Thanks
Tony