| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Copying Data from Excel to MS Outlook in Plain Text Mode | Excel Worksheet Functions | |||
| How to Transfer data from Text Form Fields in MS Word into Excel? | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
