N
nera techie nora thickiebee
My knowledge of Excel is fair but i am having a real problrm with Find and
replace that is doing my brain in. My wife has compiled a large spreadsheet
of telephone numbers that are prefaced with the German IDD in the format
0049space0123456789. She has made two mistakes - the first in inserting the
IDD when it was not required and secondly having inserted the IDD she should
have taken the leading 0 out and did not . To correct both mistakes, she
needs to remove the 0049space. Despite me formatting the cells as text and
trying every combination, F&R fails despite my every effort. I am finding the
0049 and leaving the "replace" cell blank. No deal. Any ideas what I am doing
wrong please?
replace that is doing my brain in. My wife has compiled a large spreadsheet
of telephone numbers that are prefaced with the German IDD in the format
0049space0123456789. She has made two mistakes - the first in inserting the
IDD when it was not required and secondly having inserted the IDD she should
have taken the leading 0 out and did not . To correct both mistakes, she
needs to remove the 0049space. Despite me formatting the cells as text and
trying every combination, F&R fails despite my every effort. I am finding the
0049 and leaving the "replace" cell blank. No deal. Any ideas what I am doing
wrong please?