Hey guys and gals,

I have been monkeying around with a formula and almost have it doin
what I want. Too bad I didn't have just a few more braincells or
might be able to figure it out.

I constructed a formula to append data from one cell to the cell above
but I can't get it to remove the data from the cell which informatio
was appended from. I sure hope this makes sense.

Here is what my data looks like: (each line is its own row)

12200-HN2-
000
12204-HN2-305
12206-371-
300
12206-371-305
12206-611-300
12206-ML8-300
12251-HN2-003
12252-HN2-
305
12310-HN2-000
12315-HN2-003
12351-HN2-000

16211-HN2-000

from row 2 I want to put the 000 after 12200-HN2- in row 1 and remov
the content of row two, or at least make it have a value of "xxx
literally. That way I could remove all rows that start with "xxx".

here is my formula put into another col, cell 1
=IF(RIGHT(A1,1)="-",A1&A2,A1)

This will indeed append the 000 to the line above, but it leaves th
000 there. Since my data has varying values that get cut and put o
their own line I need to remove them or rename them to somethin
consistent throughout the worksheet.


I know I'm a pain, but I have been at it for a day and a half. I'v
looked all over for something to get me started and can't figure i
out.

Any ideas?

Bill Beecha

--
billbeecha
-----------------------------------------------------------------------
billbeecham's Profile: http://www.excelforum.com/member.php...fo&userid=1628
View this thread: http://www.excelforum.com/showthread.php?threadid=27788