| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change order of 5 letter word based on another cell containing 5 numbers
Hi
This is difficult to explain so please bear with me Imagine a 5 letter word in cell A1 (ABCDE) and a 5 digit number in cell A2 (12345) then cell A3 =ABCDE if cell A2 =23451 then I need a formula to give the answer as BCDEA in cell A3 A2 is the order I need the letters to be displayed. Can it be done by a formula? Can someone help as I dont even know where to start Kenny W XP pro and Office 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display one letter of a word in a cell | Excel Worksheet Functions | |||
| change first letter of a word for an entire column | Excel Discussion (Misc queries) | |||
| Change certain numbers & blank cells into a letter | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| I want to type the letter Y in a cell and have the word Yes appea. | New Users to Excel | |||
![Forum Freak[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
