I have the following data that I am unable to automatically concatenate
because the data is always dynamic. I import this data from a text
file and I need to get "For example:" and the rows belonging to "For
example:" into one cell in a column called Example.
Here is the data with four of the varying ranges.

For example:
G026: /etc/default/login does not specify 'CONSOLE=/dev/console',
'/dev/null', or 'none'.

For example:
CRITICAL: Security Patch(es) Not Installed: (16).
CRITICAL: Recommended Patch(es) Not Installed: (16).
CRITICAL: Y2K Patch(es) Not Installed: (0).
CRITICAL: Installed Recommended Patch(es) That Are Outdated: (148).
OPTIONAL: System Software Patch(es) Not Installed/Outdated: (111).
cp6 Has (183) Missing/Old Critical Patch(es)
cp6 Has (111) Missing/Old System Software Patch(es).

For example:
-rw-rw-r-- 1 bin bin 5560 Nov 9 1998 /usr/dt/share/man/man1/xmbind.1x

For example:
-rw-rw-r-- 1 root bin 11592 Dec 7 1999 /usr/lib/libsx.so.1
-rwxrwxr-x 1 root bin 3244 Dec 3 1999
/usr/openwin/lib/locale/iso_8859_1/libs/wckind.so.0
-rwxrwxr-x 1 bin bin 103904 Nov 5 1999
/usr/openwin/lib/xil/utils/xiliUtils.so.2
-rwxrwxr-x 1 bin bin 20656 Nov 5 1999
/usr/openwin/lib/xil/devhandlers/xilCompute_SUNWkcms.so.2
-rwxrwxr-x 1 bin bin 69068 Nov 5 1999
/usr/openwin/lib/xil/devhandlers/xilIO_SUNWcg6.so.2
-rwxrwxr-x 1 bin bin 51972 Nov 5 1999
/usr/openwin/lib/xil/devhandlers/xilIO_SUNWxlib.so.2
-rwxrwxr-x 1 bin bin 36692 Nov 5 1999
/usr/openwin/lib/xil/devhandlers/xilIO_SUNWxshm.so.2
-rwxrwxr-x 1 root bin 36452 Dec 7 1999
/usr/openwin/lib/xil/devhandlers/xilIO_SUNWcg14.so.2
-rwxrwxr-x 1 root bin 1062312 Dec 7 1999
/usr/openwin/lib/xil/devhandlers/xilCompute_VIS.so.2
-rwxrwxr-x 1 root bin 1168428 Dec 7 1999
/usr/openwin/lib/xil/devhandlers/xilIO_SUNWffb.so.2


--
AwkSed2Excel
------------------------------------------------------------------------
AwkSed2Excel's Profile: http://www.excelforum.com/member.php...o&userid=23464
View this thread: http://www.excelforum.com/showthread...hreadid=374110