Break cell text up into diff cells

[vestraka]

Is there a way to find a key word and break up text according to the key
word? For example I have this in my cell

555
((BREAK))
888

Is there a way to find ((BREAK)) and put 888 in the cell below?
Thanks!

 

[Max]

Is there a way to find ((BREAK)) and put 888 in the cell below?

Venturing a thought ...
Assume data in A1 down
In B1: =IF(A1="","",A1)
In B2: =IF(A1="","",IF(A1="((BREAK))",888,A2))
Copy down as far as required. Check that col B reflects what you want. Then
copy col B and overwrite col A with a paste special as values. Clear col B.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---