Hi Juan,
This line of code works for me:
Worksheets("Sheet1").Columns(1).Replace "* ", "Total "
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
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