LinkBack URL
About LinkBacksi 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
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.
Originally Posted by brantty
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks