I need help creating a formula to separate the text from the numbers into 2 separate columns.
Examples are:
A1= WILLIAM E 68 DIMICK ST APT 3 01 VOLK 42.50
A2= JONITA ARAUJO 129 PERKINS ST #2 01 HOND 37.50
A3= QIANGWEI 8 MORTON ST APT 3 03 TOYT 47.50
The 'Text to Column' function does not work because the formatting is not consistence. What I would like is a formula that separates out the text before the FIRST numeric number. So the end result would look like:
A1: WILLIAM E B1: 68 DIMICK ST APT 3 01 VOLK 42.50
A2: JONITA ARAUJO B2: 129 PERKINS ST #2 01 HOND 37.50
A3: QIANGWEI B3: 8 MORTON ST APT 3 03 TOYT 47.50
Is there a way to create a formula that will either search or find the first number in the string and let that be the deliminater?
Thanks, K
Bookmarks