Hi,

I use excel 2003 and have a column containing data that I need to extract to
separate columns. Please see the image. the data in A is very long and image
shows just a portion of it. how do i extract INTERIOR items to INTERIOR
column, EXTERIOR items to EXTERIOR column etc.? Thanks

Column A B C D E
F G H
Facility Component exterior interior roof electrical alarms hvac
pluming


EXTERIOR
5
Paint all red,blue & yellow zones
6
Repair auto. Door opener
7
INTERIOR
8
Install access panel in ceiling
9
Install New elevator controller
10
ROOF
11
Roof Replaced Mar-06
12
ELECTRICAL
13
Install new FMCS panel
14

15
ALARMS
16
Remove SCU. Integrate with new MBS
17
Upgrade system
18
FA Panel system LV
19
HVAC / MECHANICAL
20
Aftercooler for control air system
21
Reseal all ducting
22
Replace chiller fan motors & contactors
23
PLUMBING
24
In good condition
25
TOTALS
26

27
EXTERIOR
28
Windows- Hand railing, doors, building surface (OK)
29
Modify E railing to form gate
30
INTERIOR

Is the layout consistant, where all of your column A entries have all of
those elements, e.g., Interior, exterior, etc.

If you have a lot of data and your layout is consistant, you could use
search and replace to replace INTERIOR with a symbol like a | and then use
that criteria as your delimiter in a Text to Column operation
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"sakaraat" wrote:

Hi,

I use excel 2003 and have a column containing data that I need to extract to
separate columns. Please see the image. the data in A is very long and image
shows just a portion of it. how do i extract INTERIOR items to INTERIOR
column, EXTERIOR items to EXTERIOR column etc.? Thanks

Column A B C D E
F G H
Facility Component exterior interior roof electrical alarms hvac
pluming


EXTERIOR
5
Paint all red,blue & yellow zones
6
Repair auto. Door opener
7
INTERIOR
8
Install access panel in ceiling
9
Install New elevator controller
10
ROOF
11
Roof Replaced Mar-06
12
ELECTRICAL
13
Install new FMCS panel
14

15
ALARMS
16
Remove SCU. Integrate with new MBS
17
Upgrade system
18
FA Panel system LV
19
HVAC / MECHANICAL
20
Aftercooler for control air system
21
Reseal all ducting
22
Replace chiller fan motors & contactors
23
PLUMBING
24
In good condition
25
TOTALS
26

27
EXTERIOR
28
Windows- Hand railing, doors, building surface (OK)
29
Modify E railing to form gate
30
INTERIOR