View Single Post
  #3   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Find: ","
Replace: ";"


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"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?