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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]AAA[/TD]
[/TR]
[TR]
[TD]AAAB[/TD]
[TD]ATX[/TD]
[TD][/TD]
[TD][/TD]
[TD]ATX[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]CCCCC[/TD]
[TD]DDDD[/TD]
[TD][/TD]
[TD]DDDD[/TD]
[/TR]
[TR]
[TD]1ADV[/TD]
[TD]CCC[/TD]
[TD]RNO[/TD]
[TD]XYZ1[/TD]
[TD]XYZ1[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Yes Sir. Thanks!