Sort numbers and letters, and count each

ChrisBbacon · #1 01-24-2007, 01:23 PM

My cells contain such data as this:

Cell 1 Cell 2
1a2b4c8d1e13f 1a4b3c2d4e5f

i.e. its a manual formula: 1 of a, 2 of b, 8 of d

I need to add up how many of a, how many of b, how many of c etc. to produce a total.

i.e. above there are 8 d's, and 2 d's, = 10 d's in total.

Can anyone help me with a formula to do this? I tried the MID function but it didn't work for the random cells that had two digits before some of the letters(e.g. 13f)

Thankful for ANY help

Chris

Carim · #2 01-24-2007, 01:40 PM

Hi,
Have you tried Data TexttoColumns ...?

Carim · #3 01-24-2007, 02:00 PM

Hi again,

See attached possibility ...

ChrisBbacon · #4 01-24-2007, 03:08 PM

Any chance you could explain what you did to me?

Also, I've just checked and the codes actually start with a number (which is irrelevant at this point) and instead, the number of a's, b's is indicated by the number after the letter.

i.e. 2a3b8c2d18e3f9g8k13

Can you help me change the formulas to get the same result?

and what if the data is shorter than others. e.g. just 2a3b8c2d18e
i keep getting VALUE error in the cell.

Thx

Chris

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)