I have tried four things but for some reason they do not work. I have cut and pasted a column of numbers into excel, unfortunately they have a space in the field before the number begins.
I tried to convert the column by using =trim(cell) command. Did not work.
I tried to use the Text to Columns function but could not get it to work.
I used the Replace function by Finding " " and replace with "". That did not work.
Tried a version of someone's macro here, but only ended up deleting entire number in cell when it recognized a blank space in the cell.
I am thoroughly confused. Can someone provide some help please?
I tried to convert the column by using =trim(cell) command. Did not work.
I tried to use the Text to Columns function but could not get it to work.
I used the Replace function by Finding " " and replace with "". That did not work.
Tried a version of someone's macro here, but only ended up deleting entire number in cell when it recognized a blank space in the cell.
I am thoroughly confused. Can someone provide some help please?