OT EXCEL Question

Yahoo Archive
1
Create your number list in column A. Put the following formula in column B
and copy it down the column.

=CONCATENATE("M",A1,"M")

Copy special Column B, values into any column you want.

Bob Morgan
Modern Tool, Inc.
bmorgan@...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
virago1100r
Sent: Wednesday, June 15, 2005 1:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT EXCEL Question

I was hoping someone here can give a push in the right direction.
When you enter a number in an Excel feild you can drag it down and make the
numbers progress as you go so making a list of numbers from 100 to 200 can
be done by placing 100 in the first feild then dragging the corner of the
feild done and automatically fill in 101 to 200.
Here is where I run into a problem.

The number I need to start with has letters before and after it like this.
M5683M

I need to list the numbers and have them print as a barcode list.

Any Ideas.

Thanks in advance.

Eric Tolliver
CAD Enterprises




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
I was hoping someone here can give a push in the right direction.
When you enter a number in an Excel feild you can drag it down and
make the numbers progress as you go so making a list of numbers from
100 to 200 can be done by placing 100 in the first feild then dragging
the corner of the feild done and automatically fill in 101 to 200.
Here is where I run into a problem.

The number I need to start with has letters before and after it like
this.
M5683M

I need to list the numbers and have them print as a barcode list.

Any Ideas.

Thanks in advance.

Eric Tolliver
CAD Enterprises
3
Do the letters before and after the numbers change or remain the same
throughout?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: virago1100r [mailto:e.tolliver@...]
Sent: Wednesday, June 15, 2005 12:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT EXCEL Question

I was hoping someone here can give a push in the right direction.
When you enter a number in an Excel feild you can drag it down and
make the numbers progress as you go so making a list of numbers from
100 to 200 can be done by placing 100 in the first feild then dragging
the corner of the feild done and automatically fill in 101 to 200.
Here is where I run into a problem.

The number I need to start with has letters before and after it like
this.
M5683M

I need to list the numbers and have them print as a barcode list.

Any Ideas.

Thanks in advance.

Eric Tolliver
CAD Enterprises




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
4
create a column of the number portion

5683
5684
5685
etc...


The write a formula to create the number with the prefix and suffix
="M"&TEXT(C4,"####")&"N"

Copy and paste values to fix the new fields

Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057



"virago1100r"
<e.tolliver@cable To: vantage@yahoogroups.com
az.com> cc:
Sent by: Subject: [Vantage] OT EXCEL Question
vantage@yahoogrou
ps.com


06/15/2005 01:04
PM
Please respond to
vantage






I was hoping someone here can give a push in the right direction.
When you enter a number in an Excel feild you can drag it down and
make the numbers progress as you go so making a list of numbers from
100 to 200 can be done by placing 100 in the first feild then dragging
the corner of the feild done and automatically fill in 101 to 200.
Here is where I run into a problem.

The number I need to start with has letters before and after it like
this.
M5683M

I need to list the numbers and have them print as a barcode list.

Any Ideas.

Thanks in advance.

Eric Tolliver
CAD Enterprises




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your
email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and
other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links


Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
5
I was able to do it by creating the numbers first and fill down however
far you need to. Then select the column and change the formatting to
the custom format below, changing the letters to whatever letters you
need....

\A0000\A



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: virago1100r [mailto:e.tolliver@...]
Sent: Wednesday, June 15, 2005 12:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT EXCEL Question

I was hoping someone here can give a push in the right direction.
When you enter a number in an Excel feild you can drag it down and
make the numbers progress as you go so making a list of numbers from
100 to 200 can be done by placing 100 in the first feild then dragging
the corner of the feild done and automatically fill in 101 to 200.
Here is where I run into a problem.

The number I need to start with has letters before and after it like
this.
M5683M

I need to list the numbers and have them print as a barcode list.

Any Ideas.

Thanks in advance.

Eric Tolliver
CAD Enterprises




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
6
Also, you need to change the number of 0's to however many digits you
have....

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Brandon Murch
Sent: Wednesday, June 15, 2005 12:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT EXCEL Question

I was able to do it by creating the numbers first and fill down however
far you need to. Then select the column and change the formatting to
the custom format below, changing the letters to whatever letters you
need....

\A0000\A



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: virago1100r [mailto:e.tolliver@...]
Sent: Wednesday, June 15, 2005 12:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT EXCEL Question

I was hoping someone here can give a push in the right direction.
When you enter a number in an Excel feild you can drag it down and
make the numbers progress as you go so making a list of numbers from
100 to 200 can be done by placing 100 in the first feild then dragging
the corner of the feild done and automatically fill in 101 to 200.
Here is where I run into a problem.

The number I need to start with has letters before and after it like
this.
M5683M

I need to list the numbers and have them print as a barcode list.

Any Ideas.

Thanks in advance.

Eric Tolliver
CAD Enterprises




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
7
1st change the column to text then type in 001 or 101 maybe in your case
then copy down

Do your list in 1 column and the in another column do a formula in the next
column = to =CONCATENATE("M",A1,"M")
Where A1 is your running list of numbers should work :)

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: virago1100r [mailto:e.tolliver@...]
Sent: Wednesday, June 15, 2005 2:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT EXCEL Question


I was hoping someone here can give a push in the right direction. When you
enter a number in an Excel feild you can drag it down and
make the numbers progress as you go so making a list of numbers from
100 to 200 can be done by placing 100 in the first feild then dragging
the corner of the feild done and automatically fill in 101 to 200. Here is
where I run into a problem.

The number I need to start with has letters before and after it like
this.
M5683M

I need to list the numbers and have them print as a barcode list.

Any Ideas.

Thanks in advance.

Eric Tolliver
CAD Enterprises




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links