Extrapolating information out of a cell Part 2

Your life would be much simpler if you simply run a DATA > TEXT TO COLUMNS > DELIMITED > SPACE on your column A.

This would put all your values IN separate cells where you can refer to them directly and more easily. You could copy your column A to another column and do it there is you wish to keep your original strings intact for some reason.

Hi,

assuming that you need this because there is a varying number of spaces in the text strings which makes text to columns unpracticable, you could try with your text string in A1:

Please Login or Register  to view this content.

The result is a number and can be formatted to show decimal points etc. and used in further calculations

Replace every mention of A1 with the cell address you actually have.

hth

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

Tommy, you opened this thread although you had already asked the same question in a post in your other thread. This means that JB and I were working here while NBVC was working on the other post. We do not like to waste our time.

Please read the forum rules before you post again!