Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all, I require a function/formula that adds a value to a refernce
to a cell that contains a letter of the alphabet so that the vaue returned is another letter of the alphabet. E.g. If A1 contains "L" , B1 must return "P". This works OK if I do =char(code(A1)+4), but this falls over when I go above 26/Z. I also require the answer "BC" in B1 if the letters contained in A1 are AZ...something along the lines of =function("AZ")+3 returns "BC" where cell A1 contains "AZ" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a letter to the beginning of each part number of a column | Excel Discussion (Misc queries) | |||
New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
change headers from letter to number/number to letter | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) |