Extracting text string from cell with no delimiters

Originally Posted by sandy666

based only on the first post

PC.1	PC.2	PC.3	PC.4
abcde	jklmn	ww
ww	pppp	bmbm	aabbcc
ww
abcde	ww	bmbm
jklmn	ww	pppp	bmbm

is that what you want?
verify your expected result

Yes, this is how I am hoping to display the extracted data.