| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to increase Alpha character to next letter
Why do you need to repeat post?
Posted the response below in your earlier thread: If A2 contains: A, then this in say B2: =CHAR(CODE(A2)+1) will return the next letter: B voila? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "pwinters" wrote: I am looking for a formula that will increase by one letter the alpha designation in a column. ex. A2 would be the letter 'A', B2 which would show the next letter of the alphabet should be 'B'. I know how to increase a number, ex. =(A2+1), how do I do the alphabet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if alpha character | Excel Discussion (Misc queries) | |||
| Prevent alpha character in numeric cell | Excel Discussion (Misc queries) | |||
| add alpha letter to column of numbers | New Users to Excel | |||
| Parsing a alpha character out of a cell | Excel Worksheet Functions | |||
| Numerical grade to Alpha character | Excel Discussion (Misc queries) | |||
Threaded Mode
