Adding +44 to an entire Colum!

[Dyson]

Good afternoon all,


Small problem. I currently have a colum of 275 mobile numbers, all with the 0 taken from the begining. I need to populate all the numbers with +44 at the begining. Is there a fast way of doing this?


Thanks in advance for any help!

 

[Hui]

Dyson,

Quick way would be to use Concatenate

In Row 2 of a Column to the Right or Left of your column add


=CONCATENATE("+44 ",A2)


and copy down

Assumes Your Phone Numbers are in Column A, adjust to suit


Then copy the new column and paste as values

Then replace old column with the new data

 

[Dyson]

Fantastic.......as always.


thanks