| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formulas
How do I write a formula that will enter in the next series if it is both
letters and numbers? For example in A1 I have J111 and I want J112 in C5. How would I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formulas
the easy way is to use the row number since A1 contains 111 you simply add 110
="J"&(Row()+110) "helpplease" wrote: How do I write a formula that will enter in the next series if it is both letters and numbers? For example in A1 I have J111 and I want J112 in C5. How would I do that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formulas
use this formula in C5
=CONCATENATE(LEFT(A1,1),VALUE(RIGHT(A1,LEN(A1)-1))+1) -kc *Click YES if this helps "helpplease" wrote: How do I write a formula that will enter in the next series if it is both letters and numbers? For example in A1 I have J111 and I want J112 in C5. How would I do that? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formulas
Thanks so much KC! I have been trying to think back to my college Excel
class but that was like forever ago! You're the best! "KC" wrote: use this formula in C5 =CONCATENATE(LEFT(A1,1),VALUE(RIGHT(A1,LEN(A1)-1))+1) -kc *Click YES if this helps "helpplease" wrote: How do I write a formula that will enter in the next series if it is both letters and numbers? For example in A1 I have J111 and I want J112 in C5. How would I do that? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formulas
you're welcome!
-kc "helpplease" wrote: Thanks so much KC! I have been trying to think back to my college Excel class but that was like forever ago! You're the best! "KC" wrote: use this formula in C5 =CONCATENATE(LEFT(A1,1),VALUE(RIGHT(A1,LEN(A1)-1))+1) -kc *Click YES if this helps "helpplease" wrote: How do I write a formula that will enter in the next series if it is both letters and numbers? For example in A1 I have J111 and I want J112 in C5. How would I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
| Excel Formulas | New Users to Excel | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
Linear Mode
