Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Break cell text up into diff cells
0 views
Skip to first unread message
vestraka
Oct 15, 2008, 4:01:03 PM10/15/08
to
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
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
Oct 15, 2008, 7:14:01 PM10/15/08
to
> 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
---
0 new messages