What exactly do you presently have in the list now?
If, for example, you had:
(213) 123-4567
You could use "Edit & Replace", where you "Find"
" ( " (no quotes)
And replace with " 1 ( " (no quotes).
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Jan" wrote in message
...
Trying to get a 1 to prefix phone numbers in an existing column with
thousands of entries.
thanks!
|