Good evening,

I have been given a Spreadsheet at work that was developed (MADE) by several
non-excel users, they more or less made a note pad with hundreds of lines of
info that I need.

I have cleaned most of the easier clutter from the sheet but have one area
that I am having a problem with.

We are using Excel 07. The sheet has columns A-N and is 1581 rows in
length. Most cells have only one word or one number, however there are some
that have many more and it appears that they were put in using the Alt Enter
and entered the info. The cells that have the info are part numbers that
are interchangeable on the equipment but are not playing together when I am
attempting to sort, "vlookup", etc.

Question is how can I take the cell lets say "A2" that has 3 inputs and make
it into cells A2, A3 & A4?

thanks in advance,

cil