Dmichaud61
Board Regular
- Joined
- Mar 7, 2014
- Messages
- 69
- Office Version
- 2016
- Platform
- Windows
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.
<tbody>
</tbody>
A | B | C | D | E |
AAA | AAA | |||
AAAB | ATX | ATX | ||
BBB | CCCCC | DDDD | DDDD | |
1ADV | CCC | RNO | XYZ1 | XYZ1 |
<tbody>
</tbody>