OK, I have the formula working. A big thanks for that. Now one more request.
The way it works now when I type 5 letters in cell A1 the cell containing the formula changes the letters to numbers. These messages are usually 150 groups (read cells) long. Do I paste the formula 150 times into 150 cells each time changing A1 to B1, C1, D1 and so on? I hope I am clear on my meaning here. I want to be able to type 10 cells across then start a new line 10 cells across, etc. A1 through J1, then A2 through J2, then A3 through J3, etc.
Even if I have to copy/paste 150 times I have what I need and I thank you so much!
GE
Quote:
Originally Posted by GER9999
I am having trouble with this part of your suggestion:
where I1:I10 contain the letters above
Where is I1:I10 in the formula you gave? I'm lost as to where to put the letters T,A,N,D,U,W,R,I,G,M
|