Hi,

I am having real trouble with something and wondering if anyone can help?

I am just describing a small part of a much larger system of worksheets. But say in WS1 I join 2 separate but connected figures together using =A2&","&B2 which results in data such as: 67.07787382,66.90889779 which is then distributed.

I split the data in subsequent sheets using =LEFT(A2,LEN(A2)-FIND(",",A2)),A2 (and the same to extract the right side), however, excel does not and will not read the two new numbers as numbers in calculations run through them.

Obviously if I didn't have to join them together in the first place I wouldn't, but sadly this is the only way to achieve what is necessary.

So does anyone have a solution or any advice which may help?

all the best and big TIA!