Add a nr in each row in a column
Use this in a helper column (row 2):
="+44"&I2
and then copy down. If you want to fix the values, you can highlight
all the cells with that formula in, then click <copy, then click on
Edit | Paste Special | Values (check) | OK then <Esc, and then you
can copy the column and paste it over the original values in column I.
The helper column can then be deleted.
Hope this helps.
Pete
On Jan 10, 6:13*pm, Kristian
wrote:
Hi
How do I add a country code +44 in all rows in a column?
I have mobile nr in column I but the program I am going to import the list
to needs country code before the nr. Does anyone know?
|