Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 11th 04, 02:32 PM
rgbytg
 
Posts: n/a
Default Replace function not working properly in Excel 2000 SP3

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?

  #2   Report Post  
Old November 11th 04, 02:35 PM
Frank Kabel
 
Posts: n/a
Default

Hi as * is a wildcarc charatcer use the following
~*
to search for an asterix

"rgbytg" wrote:

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?

  #3   Report Post  
Old November 11th 04, 02:36 PM
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?



  #4   Report Post  
Old November 11th 04, 02:41 PM
Ken Wright
 
Posts: n/a
Default

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


  #5   Report Post  
Old November 11th 04, 03:30 PM
rgbytg
 
Posts: n/a
Default

I guess that was a very bad example..
The main idea was that previously I was able to retain the data in the
wildcard * but no longer can.

"Ken Wright" wrote:

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





  #6   Report Post  
Old November 11th 04, 03:44 PM
rgbytg
 
Posts: n/a
Default

I think I used a really bad example. The main problem I was trying to convey
was that I can no longer use the * wildcard in the "replace with" function to
identify a placemarker.

If the wildcard "*" represents all data followed by a space, I should be
able to
say find *_A , which should state find all data followed by a
space and a "A";
and replace with *_B . which should only replace that data followed by
a space, that had a "A" and replace it with a "B".

The object is not to replace all A's, just only that which is followed by
data, space, and the letter A.
This use to work for me. Now, all I get in the field is all of my data is
"*_B", where the asterix replaced all of my previously denoted data.


"Frank Kabel" wrote:

Hi as * is a wildcarc charatcer use the following
~*
to search for an asterix

"rgbytg" wrote:

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Excel 2000 running on Windows XP SP2 does not properly open CSV fi Oscar Excel Discussion (Misc queries) 1 December 20th 04 10:10 PM
IF/ LOOKUP FUNCTION - Excel 2000 Chandrashekhar Excel Worksheet Functions 3 November 5th 04 11:02 AM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017