software

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 - - - - - -Datagt;Text to columns
Check Delimited and char = -

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

HTH
--
AP

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

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--
Herman56
------------------------------------------------------------------------
Herman56's Profile: www.excelforum.com/member.php...oamp;userid=31018
View this thread: www.excelforum.com/showthread...hreadid=527503