how do I delete the last two spaces in a cell

B

brantty

i have a cell that has numbers and then two spaces after the number. I
cannot sort correctly with the spaces. What formula will allow me to keep
the numbers and
 
M

MarkN

Hi Brantty,

Have you tried using find and replace. Select the range, find [Spacebar]
[Spacebar], leave the replace with blank and replace all
 
E

Excelenator

The "numbers" you have must have a ' in front of them if the spaces a
the end are showing up. To remove them insert a column next to the on
containing your numbers and insert the formula =TRIM(B1) into it an
copy it down for as many rows as you have. This will remove all th
spaces.
 
Top