Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum 2 +2 = 22 in Excel?
Fisher, 7+3=10, but maybe this will do what you want
=MID(A1,4,1)&MID(A1,5,1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Fisher" wrote in message ... I got a problem! Let me show it as an example: - We ave a coloumn with the number: 4567345 - my problem is, that I want to sum the 4th (7) and 5th (3) digits. The calculation is: 7 + 3 = 73. How do I that in excel? Can anybody help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum 2 +2 = 22 in Excel?
Try using & instead of +
2+2=4 2&2=22 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum 2 +2 = 22 in Excel?
Does:
=MID(A1,4,1)&MID(A1,5,1) NOT give you what you want? Where A1 is the cell that contains the value. Corey.... "Fisher" wrote in message ... "Paul B" skrev: Fisher, 7+3=10, but maybe this will do what you want =MID(A1,4,1)&MID(A1,5,1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Fisher" wrote in message ... I got a problem! Let me show it as an example: - We ave a coloumn with the number: 4567345 - my problem is, that I want to sum the 4th (7) and 5th (3) digits. The calculation is: 7 + 3 = 73. How do I that in excel? Can anybody help? Paul B Yes, in real 7 +3 = 10. But there exists some kind of "maths", that says, 2 +2 = 22, 3+5 = 35 and so on. I want to put these to digits togehter (without summing). In my case, I want to create a new 2 digts number (here by putting 7 and 3 together to 73) from the existing number (4567345) by picking out 7 and 3 and putting them together as 73. How to do that? I really need some help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum 2 +2 = 22 in Excel?
Jim gave you the answer.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Fisher" wrote in message ... "Paul B" skrev: Fisher, 7+3=10, but maybe this will do what you want =MID(A1,4,1)&MID(A1,5,1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Fisher" wrote in message ... I got a problem! Let me show it as an example: - We ave a coloumn with the number: 4567345 - my problem is, that I want to sum the 4th (7) and 5th (3) digits. The calculation is: 7 + 3 = 73. How do I that in excel? Can anybody help? Paul B Yes, in real 7 +3 = 10. But there exists some kind of "maths", that says, 2 +2 = 22, 3+5 = 35 and so on. I want to put these to digits togehter (without summing). In my case, I want to create a new 2 digts number (here by putting 7 and 3 together to 73) from the existing number (4567345) by picking out 7 and 3 and putting them together as 73. How to do that? I really need some help. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum 2 +2 = 22 in Excel?
Keep in mind that both mid and & return a text string and not a number. The
result still needs to be coerced into a value if you want to perform any kind of calculations on it... -- HTH... Jim Thomlinson "ward376" wrote: Try using & instead of + 2+2=4 2&2=22 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum 2 +2 = 22 in Excel?
Just for the record, the '+' operator works as does '&' when used on
strings. E.g., Dim S1 As String: S1 = "2" Dim S2 As String: S2 = "2" Debug.Print S1 + S2 ' displays 22 This burned me bad once. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Jim Thomlinson" wrote in message ... Keep in mind that both mid and & return a text string and not a number. The result still needs to be coerced into a value if you want to perform any kind of calculations on it... -- HTH... Jim Thomlinson "ward376" wrote: Try using & instead of + 2+2=4 2&2=22 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|