| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return an Alpha based on number position in a word
I would like to return 4 letters in a word based on their number position in
the word. In B2:B366 I have DDMM and in C1 I have a 10 letter word ABCDEFGHIJ, where A = 1 and J = 10. In C2:C366 I would like to return the 4 letters from C1 that correspond to the numbers in B2:B366. Can I do this with a formula? If so, what would this formula look like? B1 = DDMM B2 = 0104 B3 = 0204 B4 = 0304 B5 = ..... C1 = ABCDEFGHIJ C2 = JAJD C3 = JBJD C4 = JCJD C5 = ..... Thx, Don |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| Return a cell value based on specific combinations of cells in an array | Excel Worksheet Functions | |||
| Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
| Return number of current sheet | Excel Worksheet Functions | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Threaded Mode
