adding cells with numbers & letters in
adding cells with numbers & letters in
(OP)
Can Excel add cells with numbers & letters in.
e.g 41 in one cell and DF42 in another and get the total to 83? I don't want to remove the letters there is too many cells in total.
Thanks
e.g 41 in one cell and DF42 in another and get the total to 83? I don't want to remove the letters there is too many cells in total.
Thanks





RE: adding cells with numbers & letters in
Cyril Guichard
Mechanical Engineer Consultant
France
RE: adding cells with numbers & letters in
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: adding cells with numbers & letters in
=VALUE(MID(G10,3,100)) assumes DF42 is in cell G10 and the max mumber of characters for the number (42) would be 100.
RE: adding cells with numbers & letters in
Cyril Guichard
Mechanical Engineer Consultant
France
RE: adding cells with numbers & letters in
RE: adding cells with numbers & letters in
Steve
Eichenauer, Inc.
RE: adding cells with numbers & letters in
=+ISNUMBER(VALUE(MID(I15,4,1)))
Returns true if it's a digit, false otherwise.
This can be part of a nested if statement.
Can the original poster clarify what are the limits of the types of data that might be seen? Letters only on the left or possibly in the middle also? Numbers only on the right? Max number of letter or numbers or both?
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: adding cells with numbers & letters in
RE: adding cells with numbers & letters in
=+VALUE(RIGHT(H15,LEN(H15)-3))
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: adding cells with numbers & letters in
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: adding cells with numbers & letters in
RE: adding cells with numbers & letters in
a shorthand way to do what you intend, and maybe easier to understand, is to use =MID(H15, 3, 999) where the 999 is just a placeholder big number, since Excel wants something there. You should use a number which is at least as big as the longest string length.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: adding cells with numbers & letters in
=MID(H15, 4, 999)
Easy to read is in the eye of the beholder. Mine says I'm taking everything but the first 3. Yours says your starting at the 4th and taking the next 999.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: adding cells with numbers & letters in
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: adding cells with numbers & letters in
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: adding cells with numbers & letters in
Forgot now but used to type in 45 and see 45USD sometimes,with the "USD" done automatically.
regs
IJR
RE: adding cells with numbers & letters in
Actually, using a custom format is the other way around - and much easier for Excel. If you format a cell as General "USD", and you type 34 into the cell, Excel will display 34 USD. However, the cell contents are 34, which is a number, so you can do calculations with it. In this case, it looked as if scarecrow55 has imported data that contains letters and numbers. Then, you have to parse the data to get numbers for Excel to work with. After all, it is just a beefed up calculator...
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.