Forum Discussion

wyoung1969's avatar
wyoung1969
Copper Contributor
Jan 28, 2020

Trivia Score Sheet

What I'm trying to accomplish is having the letter  w   to represent a word, but also having a numerical value with it like   6w      But here is the tricky part of it, I need to have that numerical ...
excel
Formulas and Functions
mathetes's avatar
mathetes
Gold Contributor
Jan 28, 2020

wyoung1969 

 

Is your numerical value always a single digit?

Is your letter always a single letter?

Are they always sequenced NumberLetter, as in "6w" or are they sometimes "w6"?

How many columns of this kind of entry are in the row that you want to add up?

 

If it's always in the "6w" format (single digit, single letter) this formula =VALUE(LEFT(D3,1)) will return the value of the digit and could be used, in conjunction with others like it, =VALUE(LEFT(D3,1))+VALUE(LEFT(D4,1))+VALUE(LEFT(D5,1)).....

 

If it's less predictable or less consistent stuff you'll be dealing with, you'd probably be better off re-thinking the way you enter the data. Why not have separate cells for the numbers and the letters. Easy to add the numbers, and, frankly, easier to concatenate into the combinations, if that's really needed.

 

In other words, there's more to be defined here before we come up with a single "best solution"

Resources