software

Hi,

I'm trying to print out sheets of text amp; 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
Hi Sonny,

Try something like:
=LEFT(A1,7)amp;TEXT(MID(A1,8,FIND(quot; quot;,A1)-8)^1 1,quot;00000000quot;)amp;quot;
*quot;amp;LEFT(A1,7)amp;TEXT(MID(A1,8,FIND(quot; quot;,A1)-8)^1 1,quot;00000000quot;)amp;quot;*quot;

Cheersquot;Sonny Dumasquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I'm trying to print out sheets of text amp; numbers in sequence, but am (or
gt; Excel is) not producing good results.
gt;
gt; Each cell contains (example): BMN-AMS00007383 *BMN-AMS00007383*
gt; The first part being a text, the second, a bar code.
gt;
gt; If I try to use the address of the cell, (say A1) to generate a new cell
gt; (A2) based on A1 1 I get an error.
gt;
gt; I would like to get cells that continue in a sequence:
gt; BMN-AMS00007376 *BMN-AMS00007376*
gt; BMN-AMS00007377 *BMN-AMS00007377*
gt; BMN-AMS00007378 *BMN-AMS00007378*
gt; etc.
gt;
gt; They are large cells, each sheet is 7 (columns) deep and 6 (rows) wide.
gt;
gt; Thanks very much in advance,
gt; Sonny
gt;
gt;
gt;
gt;
gt;