I have a long list of phone numbers. I need to add a "+" in the beginning of
the number before I import them in Outlook.

before "+" add ' (Apostrophe symbol)


On Jun 2, 3:13*pm, Martin wrote:
I have a long list of phone numbers. I need to add a "+" in the beginning of
the number before I import them in Outlook.

but how can I add the plus to the list of numbers? I tried with "Find" and
"Replace", it didn't worked for me?

"muddan madhu" skrev:

before "+" add ' (Apostrophe symbol)


On Jun 2, 3:13 pm, Martin wrote:
I have a long list of phone numbers. I need to add a "+" in the beginning of
the number before I import them in Outlook.

try this

select the telephone numbers then ctrl + 1 , u will get format cell
window | in number tab choose custom | in type: put this +0

click ok

On Jun 2, 3:59*pm, Martin wrote:
but how can I add the plus to the list of numbers? I tried with "Find" and
"Replace", it didn't worked for me?

"muddan madhu" skrev:



before "+" add ' (Apostrophe symbol)

On Jun 2, 3:13 pm, Martin wrote:
I have a long list of phone numbers. I need to add a "+" in the beginning of
the number before I import them in Outlook.- Hide quoted text -

- Show quoted text -

Muddan,

Your suggestion won't help. Changing the format will not change the
underlying data.

Regards,
Fred.

"muddan madhu" wrote in message
...
try this

select the telephone numbers then ctrl + 1 , u will get format cell
window | in number tab choose custom | in type: put this +0

click ok

On Jun 2, 3:59 pm, Martin wrote:
but how can I add the plus to the list of numbers? I tried with "Find" and
"Replace", it didn't worked for me?

"muddan madhu" skrev:



before "+" add ' (Apostrophe symbol)

On Jun 2, 3:13 pm, Martin wrote:
I have a long list of phone numbers. I need to add a "+" in the
beginning of
the number before I import them in Outlook.- Hide quoted text -

- Show quoted text -

In a separate column, use:

="+"&a1

And copy down. Adjust the range to suit your situation.

Then either export this new column, or Copy/Paste Special...Values to
replace the old column with the new.

Regards,
Fred.

"Martin" wrote in message
...
I have a long list of phone numbers. I need to add a "+" in the beginning
of
the number before I import them in Outlook.