Sorry, I should have included more.
I am importing some numbers by copy/pasting from a web source. The numbers are in a spreadsheet format, but when you copy and past the whole line of cells (1 row, 5 columns), there are extra spaces in the cells. The values paste over to Excel but the spaces are in the left side of the value in the cell.
I am pasting these values over in, for example, cells A1 to E1 in a worksheet. I tried to put a formula in cell F1 based on the values I just pasted in but it would not work. Once I manually took out the spaces in the cells the formula in F1 worked. That made me think I needed the TRIM(cell) function but I could not get that to work.
I might just be using the formula wrong. I am not sure how to use the TRIM formula probably.
I hope that helps. I apologize for not providing a better description originally.
Thanks very much.