Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Delete text while numbers remain intact
I need to find a quick way to delete or move all letter data from a range of
cells while leaving the number data intact. I need to be able to sort my spreadsheet by the numbers in each cell, not by the letters. I could go through each cell and delete the letters manually, but I'm working with almost 2000 cells and that would be a complete waste of time. The cells I'm working with look like this "ABC 123" and I need them to look like this "123" or this "123 ABC". Any help would be greatly appreciated. |
#2
|
|||
|
|||
If there is a space in each entry, use Data-Text to
Columns-Delimited-Space to parse the entries into 2 columns - one numeric and one alpha "Sugar_grrl" wrote: I need to find a quick way to delete or move all letter data from a range of cells while leaving the number data intact. I need to be able to sort my spreadsheet by the numbers in each cell, not by the letters. I could go through each cell and delete the letters manually, but I'm working with almost 2000 cells and that would be a complete waste of time. The cells I'm working with look like this "ABC 123" and I need them to look like this "123" or this "123 ABC". Any help would be greatly appreciated. |
#3
|
|||
|
|||
One workaround:
In an adjacent column, enter =--MID(A1,FIND(" ",A1)+1,255) and copy down as far as necessary, to get just the numeric values. Sort on that column. In article , "Sugar_grrl" wrote: I need to find a quick way to delete or move all letter data from a range of cells while leaving the number data intact. I need to be able to sort my spreadsheet by the numbers in each cell, not by the letters. I could go through each cell and delete the letters manually, but I'm working with almost 2000 cells and that would be a complete waste of time. The cells I'm working with look like this "ABC 123" and I need them to look like this "123" or this "123 ABC". Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When entering numbers as text | Excel Discussion (Misc queries) | |||
Concantenate Text with numbers with fixed form | Excel Worksheet Functions | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
I enter numbers and they are stored as text | Excel Discussion (Misc queries) |