Output text from numbers

Tech-Archive recommends: Speed Up your PC by fixing your registry


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?

.

Relevant Pages

  • Re: Format text not all caps
    ... PROPER - Straight out of *Help on this function* when you look at the function ... Converts all other letters to ... =PROPERProper case of first string ... The excel file that I ...
    (microsoft.public.excel)
  • Re: Random Placement whilst fitting constraints
    ... I am newly returned to Excel after a LONG absence, so I am having to relearn everything about Excel from scratch. ... That is, for your stated requirements, put AAAAAAAAAABBBBBBBBCCCCCCCCCD in D1 (the order is unimportant as the RAND function will handle the mixing, but putting them in order makes proofing the string easier). ... and copy it down for a total of as many cells as there are letters in D1. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Ascii iinput file - separate text from Numbers
    ... Is it always letters then finishing off with numbers in each string? ... Where Bush would be in A1, assume that you put the above formula in B1, then ... Excel 95 - Excel 2007 ...
    (microsoft.public.excel.worksheet.functions)
  • Remove letters from text string
    ... I run Excel 2K ... I require a formula that removes the last 19 letters from a text string. ... I have a number of varying lengths of text strings that require the last 10 ...
    (microsoft.public.excel.newusers)
  • Re: Need help with SeriesCollection Object Please !
    ... Well Peter your explanation of my questions make sense and are sound answers. ... You seem very experienced with Excel and VBA:) ... Function GetSourceSheet(sFmla As String, sWSname, sFile As String) As ... ran my code on certain other charts sometimes it would return ...
    (microsoft.public.excel.programming)