Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I transform numbers (different ranges) to text (diff. range
I am trying to make my worksheet convert numbers to text. I want my whole F
column to convert 20 to say MUO-20, 21-50 to say MUO-50, 51-100 to say MUO-100, 101-200 to say MUO-200, and <200 to say MUO-300. Is this possible? I appreciate any help. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I transform numbers (different ranges) to text (diff. range
I think you have a couple of typos in your description.
I assume 20 means =<20 and <200 means 200 Enter this formula in G1 then double-click on the fill handle to copy down to end of date in F. =LOOKUP(A1,{0,21,51,101,201},{"muo-20","muo-50","muo-100","muo-200","muo-300"}) Gord Dibben MS Excel MVP On Tue, 12 Dec 2006 13:49:01 -0800, Ty Eaton <Ty wrote: I am trying to make my worksheet convert numbers to text. I want my whole F column to convert 20 to say MUO-20, 21-50 to say MUO-50, 51-100 to say MUO-100, 101-200 to say MUO-200, and <200 to say MUO-300. Is this possible? I appreciate any help. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
count specific text that occurs in a range of cells | Excel Discussion (Misc queries) | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions |