Select Text in After Using Text to Columns

[Dmichaud61]

Greetings! Is there a formula to fill down in column E with text from the first cell to the left that has text? The text in columns A through D are different lengths and could contain both text and numbers. I've a spreadsheet with more than 1900 rows. Thank you in advance.

A	B	C	D	E
AAA				AAA
AAAB	ATX			ATX
BBB	CCCCC	DDDD		DDDD
1ADV	CCC	RNO	XYZ1	XYZ1

<tbody>
</tbody>

 

[Peter_SSs]

Yes Sir. Thanks!