Prev: Sorting a text strings but omitting preceding "A" or "The"
Next: Show formula result in another sheet
From: ryguy7272 on 16 Dec 2009 02:05
Gord-

Sir, that's why you are an MVP!!



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"peterh" wrote:

> Eva,
>
> S/C #'s in Column "C"
> Descriptions in Column "E"
> Need result in Column "L"
>
> "Eva" wrote:
>
> > Can you elaborate more about it? You mean cells or rows?
> > --
> > Greatly appreciated
> > Eva
> >
> >
> > "peterh" wrote:
> >
> > > I am having trouble with a formula to concatenate the descriptions into 1
> > > cell for each S/C #, some have 2, 3 of 4 cells.
> > >
> > > Material No. Full Description
> > > 904120016 VALVE,SOLENOID, 240V 50HZ, HERION, P/N
> > > 9301800-0201, FOR GAS SAFETY SHUT OFF AND VENT
> > > BALL VALVES, ON ALUMINA KILNS
> > > 907010005 CABLE,BUILDING, 7/0.67, SINGLE CORE, COPPER,
> > > BLACK, PVC / V75, .6 / 1KV, 100M ROLL
> > > 907010006 CABLE,BUILDING, 7/0.67, SINGLE CORE, COPPER, RED,
> > > PVC / V75, .6 / 1KV, 100M ROLL
> > >
First  |  Prev  | 
Pages: 1 2
Prev: Sorting a text strings but omitting preceding "A" or "The"
Next: Show formula result in another sheet