add a value to and then multiply values of multiple codes in one c

[Tomkat743]

The following is a single column in a reverse billing sheet. Is it possible
for excel to pull each code individualy even if there are several codes in
one cell all seperated by a dash? Even better can it assign a fixed dollar
amount to each code and calculate the total dollar value of that cell? I have
a total of 25 codes and each equates to a fixed dollar value. I am using
Excel 2003. Thanks in advance for any help on this.

CODES
2A - 1L - 5C - 2K- - - -
1L - 5C - - - - - -
5X - 2K - 2K - 2K - - - -
1A - 2A - 5C - - - - -
1E - 2A - 1L - - - - -
5X - 1L - 1E- - - - -
3C - 1E - - - - - -
1A - 1E - - - - - -

[Ardus Petus]

Data>Text to columns
Check Delimited and char = -

You will have to type the $ amount corresponding to each code

HTH
--
AP

"Tomkat743" <Tomkat743@discussions.microsoft.com> a écrit dans le message de
news:B78F8F8F-1166-491E-9376-10C57E40DA1F@microsoft.com...
> The following is a single column in a reverse billing sheet. Is it
possible
> for excel to pull each code individualy even if there are several codes in
> one cell all seperated by a dash? Even better can it assign a fixed dollar
> amount to each code and calculate the total dollar value of that cell? I
have
> a total of 25 codes and each equates to a fixed dollar value. I am using
> Excel 2003. Thanks in advance for any help on this.
>
> CODES
> 2A - 1L - 5C - 2K- - - -
> 1L - 5C - - - - - -
> 5X - 2K - 2K - 2K - - - -
> 1A - 2A - 5C - - - - -
> 1E - 2A - 1L - - - - -
> 5X - 1L - 1E- - - - -
> 3C - 1E - - - - - -
> 1A - 1E - - - - - -
>

[Herman56]

Why don't you create a help table, in which you all all of your present and future codes with all the proper prices they stand for? This way you can have VLOOKUP getting all the proper amounts and a SUMIF formula to sum them all together. Depends on the structure of your table, and the columns present.

Paul