text & number sequence
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 |
text & number sequence
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 |
All times are GMT +1. The time now is 09:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com