I cannot get rid of a trailing space in a cell.
The contents is always a string value although consisting of digits and this trailing space or something that I can't see.
The length of the string varies and sometimes the space is not there. so I can't use Left() function.
I have tried Trim() and Clean()
Can anyone help please.
I attach a small spreadsheet with the cell with the trailing space in and what I tried.
I Use W7 and Office 2010