Subtotal copy cleanup

[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

 

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