Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Output text from numbers
I would like to find a way of getting excel to interpret numbers associated
with letters and output a text string. What I want to do is then use this text string with a conditional format to provide a horizontal colour sequence. Example below for how the table is required to output the text string. I 2 4 Input E 1 2 W 3 Output desired I I E W W W E E I I I I In any one column there will only be one number so excel needs to scan the left most column first and repeat in a row in separate cells the number of letters quoted in the table for that input. Then scan the second column and output the letter x times in the next cell along etc. Do you know if this is possible with Excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are numbers stored as text in my TOAD created Excel output? | Excel Discussion (Misc queries) | |||
Comparing cells and output text | Excel Worksheet Functions | |||
How to output text that blinks? | Excel Discussion (Misc queries) | |||
add text to end of formula output | Excel Discussion (Misc queries) | |||
Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) |