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

Hi Brantty,

Have you tried using find and replace. Select the range, find [Spacebar]
[Spacebar], leave the replace with blank and replace all
--
Hope this helps,
MarkN


"brantty" wrote:

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

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

brantty Wrote:
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


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565421