HELP WITH FORMULA
 

Hi, anyone who can help me with thsi problem:

I have column with numbers:

1001
1002
1003
etc

I want to insert an "A" at the end of the number

1001A
1002A
1003A

How do I accomplish that. Help would be much grateful

Rgds

Rickard

HELP WITH FORMULA
 

Hi,

One wayis to put an A somewhere in a cell and copy it (D1) in my case
then if your numbers are in A1 don put this in B1
=A1&$D$1
and double click the fill handle
The copy column B and paste it back in to column A with
Edit|Paste Special|values
Delete column B

Mike

"Yzer" wrote:

Hi, anyone who can help me with thsi problem:

I have column with numbers:

1001
1002
1003
etc

I want to insert an "A" at the end of the number

1001A
1002A
1003A

How do I accomplish that. Help would be much grateful

Rgds

Rickard

HELP WITH FORMULA
 

Incredible.......that I could get help that fast...thanks a lot !!!!....you
saved my day.

Rickard

"Mike H" wrote:

Hi,

One wayis to put an A somewhere in a cell and copy it (D1) in my case
then if your numbers are in A1 don put this in B1
=A1&$D$1
and double click the fill handle
The copy column B and paste it back in to column A with
Edit|Paste Special|values
Delete column B

Mike

"Yzer" wrote:

Hi, anyone who can help me with thsi problem:

I have column with numbers:

1001
1002
1003
etc

I want to insert an "A" at the end of the number

1001A
1002A
1003A

How do I accomplish that. Help would be much grateful

Rgds

Rickard

HELP WITH FORMULA
 

Your welcome and thanks for the feedback

Mike

"Yzer" wrote:

Incredible.......that I could get help that fast...thanks a lot !!!!....you
saved my day.

Rickard

"Mike H" wrote:

Hi,

One wayis to put an A somewhere in a cell and copy it (D1) in my case
then if your numbers are in A1 don put this in B1
=A1&$D$1
and double click the fill handle
The copy column B and paste it back in to column A with
Edit|Paste Special|values
Delete column B

Mike

"Yzer" wrote:

Hi, anyone who can help me with thsi problem:

I have column with numbers:

1001
1002
1003
etc

I want to insert an "A" at the end of the number

1001A
1002A
1003A

How do I accomplish that. Help would be much grateful

Rgds

Rickard