Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers disguised as Text - Sorting Delima
I have a spreadsheet where it appears there are numbers in column A. To my
surprise they are acutally represented as text. I used the =isnumber formula to test which came back false. What i need to do is convert these alpha numbers to actual text in order to sort. Is there a way to do this? -- Sandi Gardner |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers disguised as Text - Sorting Delima
I select an empty cell
edit|copy select column A edit|Paste special|Check Add (and maybe reformat the column) Sandi wrote: I have a spreadsheet where it appears there are numbers in column A. To my surprise they are acutally represented as text. I used the =isnumber formula to test which came back false. What i need to do is convert these alpha numbers to actual text in order to sort. Is there a way to do this? -- Sandi Gardner -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers disguised as Text - Sorting Delima
Hi Dave - I saw where you had posted that response to someone else's request
and I tried that but it doesn't work for me. I tried the LEN function and i can tell that there are hidden characters within the text. Not sure how to fix this, but it's driving me crazy. -- Sandi Gardner "Dave Peterson" wrote: I select an empty cell edit|copy select column A edit|Paste special|Check Add (and maybe reformat the column) Sandi wrote: I have a spreadsheet where it appears there are numbers in column A. To my surprise they are acutally represented as text. I used the =isnumber formula to test which came back false. What i need to do is convert these alpha numbers to actual text in order to sort. Is there a way to do this? -- Sandi Gardner -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers disguised as Text - Sorting Delima
Maybe you have other stuff in that cell.
It might be one of those HTML non-breaking space characters. David McRitchie has a macro that cleans up this kind of stuff: http://www.mvps.org/dmcritchie/excel/join.htm#trimall (look for "Sub Trimall()") If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Sandi wrote: Hi Dave - I saw where you had posted that response to someone else's request and I tried that but it doesn't work for me. I tried the LEN function and i can tell that there are hidden characters within the text. Not sure how to fix this, but it's driving me crazy. -- Sandi Gardner "Dave Peterson" wrote: I select an empty cell edit|copy select column A edit|Paste special|Check Add (and maybe reformat the column) Sandi wrote: I have a spreadsheet where it appears there are numbers in column A. To my surprise they are acutally represented as text. I used the =isnumber formula to test which came back false. What i need to do is convert these alpha numbers to actual text in order to sort. Is there a way to do this? -- Sandi Gardner -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers disguised as Text - Sorting Delima
Thanks Dave - I will try that and see if it work! Thanks for the help!
-- Sandi Gardner "Dave Peterson" wrote: Maybe you have other stuff in that cell. It might be one of those HTML non-breaking space characters. David McRitchie has a macro that cleans up this kind of stuff: http://www.mvps.org/dmcritchie/excel/join.htm#trimall (look for "Sub Trimall()") If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Sandi wrote: Hi Dave - I saw where you had posted that response to someone else's request and I tried that but it doesn't work for me. I tried the LEN function and i can tell that there are hidden characters within the text. Not sure how to fix this, but it's driving me crazy. -- Sandi Gardner "Dave Peterson" wrote: I select an empty cell edit|copy select column A edit|Paste special|Check Add (and maybe reformat the column) Sandi wrote: I have a spreadsheet where it appears there are numbers in column A. To my surprise they are acutally represented as text. I used the =isnumber formula to test which came back false. What i need to do is convert these alpha numbers to actual text in order to sort. Is there a way to do this? -- Sandi Gardner -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
Sorting order - text and numbers | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) |