Concantinate Cells

[BBoner]

I received a price list from a company I sell products for.

They put all of thier descriptions in column "b" in separate cells,
I need to concantenate these cells into one cell.

The First column has the part number, the second has the description,
the third has the price.

The second column has mutiple cells for the description, so the first
"a" and last "c" columns have blank cells where the extra cells are in
the second "b" column containing the description.

I hope you can help me, I neeb to import these prices into a quoting
program.

Thank You,
BB

 

[Norman Harker]

Hi BB!

It sounds like you need temporary helper rows to concatenate the
descriptions:

A typical concatenation would be:

=B1&" "&B2

You can then use
Copy
Edit > Paste Special > Values > OK

The result can then be cut and pasted to the first row and you can
then delete the excess row.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[BBoner]

Thank you for the reply.

I have tried this before but the decriptions are of differen
lengths.

Some have more cells to join than others.

I tried doing this for each item, but the list is far to long.

I am looking for a formula from a specific cel down to a blank cell.

There are blank cells betwee each set of cells containing th
description.

Example:

Blank cell< B2
PK 6001 Palfinger Hydraulic Loader <Cell B3
Max. lifting moment 39,080 ft-lbs. hydr. Outreach 17'-8", rotatio angle<Cell B4
400 deg. Telescopic outriggers manually ext. to 14'-3" (R2), dua operator ctrls <Cell B5
Load holding valves on lift, fold & ext.cyldr's plus return oi utilization<Cell B6
Oil tank (13.2 US gal.) with return filter and high pressure filter <Cell B7
Blank Cell< B8

2 Section Hydraulic Boom Extension<CEll B9
2 section hydraulic boom extension from 17'-8" to 24'-3". <Cell B10

Blank Cell< B11

With a conditioal formula I should be able to paste it in another colu
to have it automaticaly concantinate the descriptions for each item.

This is where my ignorance of Excell comes in.

Regards,
B

 

[Jonathan Rynd]

Some have more cells to join than others.

Then you'll have to write a userdefined function, say in Visual Basic. It
can loop over cells until a blank cell and concatenate everything.