View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ty Eaton Ty Eaton is offline
external usenet poster
 
Posts: 1
Default 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.