Subtotal copy cleanup

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
 
V

Vasant Nanavati

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.
 
Top