Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 13th 09, 03:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 6
Default Find and Replace function not working

I have three different list of customers, actually one list that is set up
based on different criteria, (#1 name, #2 address, #3 salesman). Each list is
set up so that each beginning letter is seperated as such;
A
Adams
B
Bobby

On one list, the "find and replace" feature works perfect, the next one it
works sometimes, not all the time, and the last list it does not work at all.
What is the problem? And how do I fix it?

Thanx

  #2   Report Post  
Old April 14th 09, 07:17 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 1
Default Find and Replace function not working


How are your lists built?, are they created by formula or is it a table?
has the data been imported?

It's quite possible that you have leading spaces or similar problem.

wt.pm;305921 Wrote:
I have three different list of customers, actually one list that is set
up
based on different criteria, (#1 name, #2 address, #3 salesman). Each
list is
set up so that each beginning letter is seperated as such;
A
Adams
B
Bobby

On one list, the "find and replace" feature works perfect, the next one
it
works sometimes, not all the time, and the last list it does not work
at all.
What is the problem? And how do I fix it?

Thanx



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85534

  #3   Report Post  
Old April 14th 09, 05:16 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 6
Default Find and Replace function not working

I guess you would call it a table, I entered it by hand. Here is a cut &
paste of the list, (I have changed sensitive data), however I have put in a
data filter function, that you can not see, on the line that has "name phone
etc"So I have added an "^" here to represent that. I am showing grid lines,
and have "conditional formated" so that every other row is shaded.

Name^ Phone #^ Address^ City^
A
Allen Jeffery 555-5555 226 Market St Apt #28 Detroit
Arnold Mary 555-5555 123 Street Miami
B




"Simon Lloyd" wrote:


How are your lists built?, are they created by formula or is it a table?
has the data been imported?

It's quite possible that you have leading spaces or similar problem.

wt.pm;305921 Wrote:
I have three different list of customers, actually one list that is set
up
based on different criteria, (#1 name, #2 address, #3 salesman). Each
list is
set up so that each beginning letter is seperated as such;
A
Adams
B
Bobby

On one list, the "find and replace" feature works perfect, the next one
it
works sometimes, not all the time, and the last list it does not work
at all.
What is the problem? And how do I fix it?

Thanx



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85534




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: Why Find and Replace not working? Mr. Low Excel Discussion (Misc queries) 6 January 6th 09 03:37 PM
Disable Find-Replace Function FARAZ QURESHI Excel Discussion (Misc queries) 0 January 4th 07 06:58 PM
My Find and Replace function in Excel is not working? BPeach Excel Worksheet Functions 2 December 20th 06 11:27 PM
Help! - Lost function in Find & Replace! jmn13 Excel Discussion (Misc queries) 1 May 25th 06 06:16 PM
Replace function not working properly in Excel 2000 SP3 rgbytg Excel Worksheet Functions 5 November 11th 04 03:44 PM


All times are GMT +1. The time now is 05:02 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