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?

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?

Kristian;176689 Wrote:
How do I add a country code +44 in all rows in a column? I have mobile
[number] in column I but the program I am going to import the list to
needs country code before the [number]. Does anyone know?

One way is to use a helper column, at least temporarily.

If the numbers are in column A, then in an empty column at the top,
enter:

="+44 "&A2

...and copy that down. When you get the look you want in the new
column, copy the whole range then EDIT PASTE SPECIAL Values over the
original column A, then delete your helper column.

Export.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48891

Suppose these entries are in column A
If necessary (ie column B is being used) insert a new column B
In B1 enter ="+44"&A1 and copy down the column - the quickest way is to
double click B1's fill handle (small solid square in lower right corner of
the active cell)

Now let's convert the formulas to values: select all the B formulas and use
Copy; with them still selected use Edit | Paste Special with Values
specified; click OK
Now you can delete column A as B has what you need

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kristian" wrote in message
...
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?

Hi,

In a helper column use this formula

="+44"&A1

I believe you need to drop the leading zero when using the country code so
maybe this

="+44"&RIGHT(A1,LEN(A1)-1)

Copy this column and paste it back on top of itself with
edit|Paste special - values

Delete the original column

Mike





"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?

Thanks to everyone.

Mike H skrev:

Hi,

In a helper column use this formula

="+44"&A1

I believe you need to drop the leading zero when using the country code so
maybe this

="+44"&RIGHT(A1,LEN(A1)-1)

Copy this column and paste it back on top of itself with
edit|Paste special - values

Delete the original column

Mike





"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?