| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 46651 | 2004-07-01 05:01:00 | XL formula | B.M. (505) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 248841 | 2004-07-14 04:54:00 | The trouble with "Find" Russell is it's case sensitive where "Search" isn't. :( I don't think it will work with wild cards either??? :( :( :( |
B.M. (505) | ||
| 248842 | 2004-07-14 05:03:00 | > As for your formula being ugly Andrew, let me assure > you it was a thing of great beauty compared to some > of mine! :D Thank you, any XL queries, just ask! :D |
andrew93 (249) | ||
| 248843 | 2004-07-14 05:39:00 | > The trouble with "Find" Russell is it's case sensitive where "Search" isn't. Well - thinking laterally - if you do Ctrl-F on the worksheet and FIND "paint" and ReplaceAll with "paint", every instance of PAINT, Paint, pAiNT etc will be changed to "paint" as this FIND is not case sensitive, do the same for "paper", and the formula FIND case sensitivity issue disappears. |
Russell D (18) | ||
| 1 2 3 | |||||