Why wouldn't you just replace , with ; - Should be no need for a wildcard.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"rgbytg" wrote in message
...
Whenever I attempt to use the "*" option in Excel, I use to be able to place
this in the replace with field to keep the same data as reference followed or
preceeded by the noted change. Example:
Smith, Carol
Jones, Cathy
Williams, Bill
Find: *,_
Replace with: *;_
to get:
Smith; Carol
Jones; Cathy
Williams; Bill
Now it just replaces all my data with an "*" and it looks like this:
*;
*;
*;
Has anyone experienced this or have a different solution?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004