Just in case you could use a solution that put the numbers into single cells:-
With your data in cell A1, create your list of values in a table say A5:B30. Now in any cell, type = and then select the area A5:B30, then hit F2 and F9 and enter. Copy the 'contents' of the cell and then do Insert / Name / Define (Call it MyList) and paste in the value from the cell, which will look something like this:-
={"a",7;"b",11;"c",23;"d",18;"e",4;"f",26;"g",5;"h",20;"i",15;"j",12;"k",25;"l",21;"m",2;"n",3;"o",24;"p",1;"q",10;"r",8;"s",22;"t",6;"u",14;"v",9;"w",13;"x",17;"y",19;"z",16}
You can now delete your table in A5:B30
Now select as many cells as you think will need to use - You can select far more than you need to cover large words, eg C1:BZ1 and then in the formula bar, paste in the following formula:-
=IF(ISERROR(VLOOKUP(MID(A1,COLUMN(INDIRECT("A:BX"

),1),MyList,2,0)),"",VLOOKUP(MID(A1,COLUMN(INDIRECT("A:BX"

),1),MyList,2,0))
Now hit CTRL+SHIFT+ENTER to array enter it.
Format your column widths as 2 or something like that.
The A:BX simply maps to the same number of cells as the C:BZ range and can be changed as you prefer.
Regards
Ken..................
----------------------------------------------------------------------------
![[peace] [peace] [peace]](/data/assets/smilies/peace.gif)
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------