View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Mac John Mac is offline
external usenet poster
 
Posts: 2
Default Excel - convert data into text

I wish to assign text to data values - for example if a cell contains 3.1
then I wish it to given the text equivalent 3c, 3.5 given 3b, 3.9 given 3a,
4.1 given 4c, 4.5 given 4b etc..
All this needs to be done in a seperate column next to the original data