In the Find What box, type ~* followed by 2 spaces
In the Replace With box, type Total and 1 space


On Wed, 28 Jul 2004 12:25:13 -0700, "Juan" wrote:

Hello all,
I have in Column A customers that have a * and two extra
spaces.These customers that contain such thing is the
total for that customer . Example,
Column A
* Test Tech
* tech is this

Is it possible to replace the *Spacespace to Total?Exa,
Total Test Tech
Total tech is this

If I do the Find Replace, it will cause some errors
because of the * and space.
Please advise any help.
Thanks,
Juan