Hi,

wondering if it is possible to combine information that is located in
various area of the list.

abcd
1.merchant settlement date: 06/01/09
2.1234
3. sale amount
4.total 500.00

Ideally would like the combine to be 1234060109500.00 which may formulate as
=A2&C1&C4

BUT in every batch of total the line vary. some time it has 7 lines some
time it only have one. so with the new column on combine information when use
for a continuation don't work.

Is there a way base on the information on the above/below, and next to cell.
Like if a number under merchant plus the date next to settlement date the
number next to total . is this possible?

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bklynhyc" wrote in message
...
Hi,

wondering if it is possible to combine information that is located in
various area of the list.

abcd
1.merchant settlement date: 06/01/09
2.1234
3. sale amount
4.total 500.00

Ideally would like the combine to be 1234060109500.00 which may formulate
as
=A2&C1&C4

BUT in every batch of total the line vary. some time it has 7 lines some
time it only have one. so with the new column on combine information when
use
for a continuation don't work.

Is there a way base on the information on the above/below, and next to
cell.
Like if a number under merchant plus the date next to settlement date the
number next to total . is this possible?

I dont get one and two

"Don Guillett" wrote:

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bklynhyc" wrote in message
...
Hi,

wondering if it is possible to combine information that is located in
various area of the list.

abcd
1.merchant settlement date: 06/01/09
2.1234
3. sale amount
4.total 500.00

Ideally would like the combine to be 1234060109500.00 which may formulate
as
=A2&C1&C4

BUT in every batch of total the line vary. some time it has 7 lines some
time it only have one. so with the new column on combine information when
use
for a continuation don't work.

Is there a way base on the information on the above/below, and next to
cell.
Like if a number under merchant plus the date next to settlement date the
number next to total . is this possible?

Not rocket science.
1.On your fileinsert a worksheet and copy/paste this msg to that sheet
2. In the subject of your email use the same subject shown here and tell me
the name of the newsgroup you posted to..
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bklynhyc" wrote in message
...
I dont get one and two

"Don Guillett" wrote:

If desired, send your file to my address below. I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bklynhyc" wrote in message
...
Hi,

wondering if it is possible to combine information that is located in
various area of the list.

abcd
1.merchant settlement date: 06/01/09
2.1234
3. sale amount
4.total 500.00

Ideally would like the combine to be 1234060109500.00 which may
formulate
as
=A2&C1&C4

BUT in every batch of total the line vary. some time it has 7 lines
some
time it only have one. so with the new column on combine information
when
use
for a continuation don't work.

Is there a way base on the information on the above/below, and next to
cell.
Like if a number under merchant plus the date next to settlement date
the
number next to total . is this possible?