listing the number 1 at the end of

[lech]

Is there a way to list the number 1 at the end in a field after a
certain character using excel or anything else.

It's from a product datafeed that has this format:

Product name #12345 should be 123451
Product name 14548 should be 145481

All my data sits in column a1:a3018.

Please help. Thanks alot!

Lech

 

[Guest]

=CONCATENATE(A1,1)
where A1 is the cell of the number to which you want to
append the 1

where 1 is the number you want to append.

Do this for each cell you want to append the 1 by
dragging it down.

 

[Don Guillett]

for each c in selection
c.value=c&"1"
next

 

[Gord Dibben]

Lech

Assuming product numbers are in Column A.

In another column enter =A1&1

This will result in Text value.

As an aside. If you wish to use these for calculation use this instead.

=(A1&1)+0

Gord Dibben XL2002

 

[Don Guillett]

In another column enter =A1&1

This will result in Text value.

As an aside. If you wish to use these for calculation use this instead.

=(A1&1)+0

Gord, I just tried =a1&1 in b1 and in c1 put =b1+4 and got the right answer.
general format all the way
--
Don Guillett
SalesAid Software
(e-mail address removed)

Lech

Assuming product numbers are in Column A.

In another column enter =A1&1

This will result in Text value.

As an aside. If you wish to use these for calculation use this instead.

=(A1&1)+0

Gord Dibben XL2002