text & number sequence

S

Sonny Dumas

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
 
M

macropod

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

search in the entire sheet for different letter and cal. 7
if the numbers in sequence 11
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
sequence of numbers 3
replace dash in a number sequence 1
Combining text from several cells into 1 cell 4
how do I automatically sequence the month 4
Converting Text to Number 3

Top