I have a column with multiple length item numbers and some of the cells
contain "spaces" following the number, i.e. "00014C ". This example shows
that there are 6 text characters plus 4 spaces, I can get rid of the spaces
easily for this example, but when i have a column with thousands of rows each
with different number of text characters and different number of spaces, it's
hard to do. Please help!