Hi Sonny,

Try something like:
=LEFT(A1,7)&TEXT(MID(A1,8,FIND(" ",A1)-8)^1+1,"00000000")&"
*"&LEFT(A1,7)&TEXT(MID(A1,8,FIND(" ",A1)-8)^1+1,"00000000")&"*"

Cheers


"Sonny Dumas" wrote in message
...
Hi,

I'm trying to print out sheets of text & numbers in sequence, but am (or
Excel is) not producing good results.

Each cell contains (example): BMN-AMS00007383 *BMN-AMS00007383*
The first part being a text, the second, a bar code.

If I try to use the address of the cell, (say A1) to generate a new cell
(A2) based on A1+1 I get an error.

I would like to get cells that continue in a sequence:
BMN-AMS00007376 *BMN-AMS00007376*
BMN-AMS00007377 *BMN-AMS00007377*
BMN-AMS00007378 *BMN-AMS00007378*
etc.

They are large cells, each sheet is 7 (columns) deep and 6 (rows) wide.

Thanks very much in advance,
Sonny