Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Text
how does the formula =a1+1 work for letters instead of numbers? I have in c2
the letter "a" and in c3 i want to add b..which is simple by typing "b"...but if i need 10 or more letters in a2:a25 or a28, how does the formula work? sorry for the confusion....and thanks for the help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Text
enter this formula and fill down as far as you want (not more than 26 rows(!)):
=CHAR(96+ROW(A1)) "scott" wrote: how does the formula =a1+1 work for letters instead of numbers? I have in c2 the letter "a" and in c3 i want to add b..which is simple by typing "b"...but if i need 10 or more letters in a2:a25 or a28, how does the formula work? sorry for the confusion....and thanks for the help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Text
You have to convert the character to the ascii code using CODE and add.
Putting this formula in C3 and copying down the column wilshow you how this works =CHAR(CODE(C2)+1) "scott" wrote: how does the formula =a1+1 work for letters instead of numbers? I have in c2 the letter "a" and in c3 i want to add b..which is simple by typing "b"...but if i need 10 or more letters in a2:a25 or a28, how does the formula work? sorry for the confusion....and thanks for the help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Text
=CHAR(CODE(C2)+1)
- if I understand you right ? HTH. Best wishes Harald "scott" wrote in message ... how does the formula =a1+1 work for letters instead of numbers? I have in c2 the letter "a" and in c3 i want to add b..which is simple by typing "b"...but if i need 10 or more letters in a2:a25 or a28, how does the formula work? sorry for the confusion....and thanks for the help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Text
use &
=A2&A3&A4........... scott wrote: how does the formula =a1+1 work for letters instead of numbers? I have in c2 the letter "a" and in c3 i want to add b..which is simple by typing "b"...but if i need 10 or more letters in a2:a25 or a28, how does the formula work? sorry for the confusion....and thanks for the help |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Text
Your subject line says "summing"
But your description doesn't seem to match that. What do you want to do? Count cells with letters? =counta(a2:a25) Or put all the letters in one cell? =a2&a3&a4&a5&a6 etc. Or a UDF Function ConCatRange(CellBlock As Range) As String Dim Cell As Range Dim sbuf As String For Each Cell In CellBlock If Len(Cell.text) 0 Then sbuf = sbuf & Cell.text & " " Next ConCatRange = Left(sbuf, Len(sbuf) - 1) End Function Usage is =concatrange(A2:A25) Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 12:12:01 -0700, scott wrote: how does the formula =a1+1 work for letters instead of numbers? I have in c2 the letter "a" and in c3 i want to add b..which is simple by typing "b"...but if i need 10 or more letters in a2:a25 or a28, how does the formula work? sorry for the confusion....and thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing a row with text in some cells | Excel Discussion (Misc queries) | |||
need help summing text in column | Excel Worksheet Functions | |||
summing cells with text and numbers | Excel Worksheet Functions | |||
Summing range that contains text | Excel Worksheet Functions | |||
Summing cells that contain numbers and text | Excel Discussion (Misc queries) |