G Guest May 29, 2006 #1 Sometimes the edit -find command is not able to locate text that is present in the worksheet. What am I doing wrong ?
Sometimes the edit -find command is not able to locate text that is present in the worksheet. What am I doing wrong ?
S Sandy Mann May 29, 2006 #3 Most of the time that this happens to me I have inadvertantly selected a range of two cells or more without noticing. It could also be that there is a space, or other invisible character, before or after the text. -- HTH Sandy In Perth, the ancient capital of Scotland (e-mail address removed) (e-mail address removed) with @tiscali.co.uk
Most of the time that this happens to me I have inadvertantly selected a range of two cells or more without noticing. It could also be that there is a space, or other invisible character, before or after the text. -- HTH Sandy In Perth, the ancient capital of Scotland (e-mail address removed) (e-mail address removed) with @tiscali.co.uk
G Guest May 29, 2006 #4 fin_model said: Sometimes the edit -find command is not able to locate text that is present in the worksheet. What am I doing wrong ? Click to expand... In order to search the whole worksheet only one cell must be selected. If the text is not located, click on any cell and try again. HTH
fin_model said: Sometimes the edit -find command is not able to locate text that is present in the worksheet. What am I doing wrong ? Click to expand... In order to search the whole worksheet only one cell must be selected. If the text is not located, click on any cell and try again. HTH
