Subtotal copy cleanup

  • Thread starter Thread starter Soz
  • Start date Start date
S

Soz

Experts,
I've learned from your newsgroup how to copy only the total lines from the
subtotal feature. After I've cut and pasted this data I'm left with the
following example:

Tom Jones Total
Henry Winkler Jr. Total
Wits End Total

Is there a quick way of stripping the different amounts of special
characters/spaces and Total from these lines. I need to use the VLOOKUP on
the names to reference other data.
Thanks to all for the helpful tips.
Soz
 
First, use Edit | Replace to replace "Total" (without the quotes) with
nothing.

Then, use TRIM to ignore the trailing spaces; e.g.:

=VLOOKUP(TRIM(A1),...... , etc.
 
Back
Top