Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
number returns only two decimal places after I change from text | Excel Discussion (Misc queries) | |||
making a number be text | Excel Worksheet Functions | |||
Format Number to Text | Excel Worksheet Functions |