Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Why Find and Replace not working? | Excel Discussion (Misc queries) | |||
Disable Find-Replace Function | Excel Discussion (Misc queries) | |||
My Find and Replace function in Excel is not working? | Excel Worksheet Functions | |||
Help! - Lost function in Find & Replace! | Excel Discussion (Misc queries) | |||
Replace function not working properly in Excel 2000 SP3 | Excel Worksheet Functions |