sábado, 11 de dezembro de 2010

[Access VBA Central] How to Concatenate multiple columns of numbers?

 

How to Concatenate multiple columns of numbers?
I am using Excel 2007 VBA -- and need to concatenate 100 columns
of numbers into 50, with 2137 rows. If a cell is empty, then do
not concatenate. End script when first empty row is reached.
Two columns of numbers will be concatenated and separated by
an underscore.

Numbers in each cell come from database, and will appear
to be random to the casual observer, though each number has
significant meaning.

Example:

Columns
A1----B1----C1----D1----E1----F1
12----2----13----1----256----3

After VBA script is run:

Columns
A1------B1------C1
12_2----13_1----256_3

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


Hobbies & Activities Zone: Find others who share your passions! Explore new interests.


Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!

.

__,_._,___

Nenhum comentário:

Postar um comentário