| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
No, I just assumed that she didn't have more than 26 items as she didn't
specify what to do when one got past "Z.". Turns out it was the right assumption, as I got an email from her stating that it "worked exactly as [she] wanted it to." -- Vasant "Harlan Grove" wrote in message ... "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote... =CHAR(CODE(MID(A$1,1,1))+ROW(A1))&MID(A$1,2,1)+RO W(A1) &MID(A$1,3,1)+ROW(A1)&MID(A$1,4,1)+ROW(A1)&MID(A$ 1,5,1) +ROW(A1)&MID(A$1,6,1)+ROW(A1) assuming your data starts in cell A1 with the entry "A12345." Do you suppose the OP really wants to go from Z2627282930 in A26 to [2728293031 in A27? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP WITH ALPHA NUMERIC | Excel Worksheet Functions | |||
| Columns are now numeric, not alpha. how to change back? | Excel Discussion (Misc queries) | |||
| Search string for alpha or numeric | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
| Alpha & Numeric Counts in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
