RICHMATERIALS
New Member
- Joined
- Feb 27, 2008
- Messages
- 8
Ladies and Gents,
I have a column of six digit numbers, each of which are preceded with a single lower case "o". I would like to replace the "o" in each value with a numeric "0", on the entire column at once using find/replace.
I have formatted column to text, but to no avail - result redacts the preceding zero.
Thanks
Rich
I have a column of six digit numbers, each of which are preceded with a single lower case "o". I would like to replace the "o" in each value with a numeric "0", on the entire column at once using find/replace.
I have formatted column to text, but to no avail - result redacts the preceding zero.
Thanks
Rich