TRIM FUNCTION TO PULL OUT 3rd KEY DATA from each cell.

Hi,

I have a test spreadsheet I'm trying to use the TRIM Function for to extra the third piece of data from each cell from A2 across and down.

However I can't get it to work correctly and my knowledge of the TRIM function is limited and I can't work out where I'm going wrong.

My example book shows the data I want in sheet 1 highlighted in red. this is replicated down a few rows and would also apply to each column to the right for each calendar day.

In sheet 2 I have the trim formula (not working) trying to delete out the data I don't want to leave the corresponding correct data as highlighted in red in sheet1.

Any help appreciated.

Thanks, unfortunately this doesn't quite work as not every cell in sheet 1 contains the same amounts of data. e.g. most cells will have 3 or 4 bits of data. It is always the 3rd bit of data that is needed but the Trim formula suggested is it appears looking for the 4th piece of data not the 3rd.