After importing a comma delimited text file one column is "5701-5799 Rutgers St- West University Place "
"101-99 Gold St- Highlands "
"2-38 Small St- West University Place "
The result prefered is to place the block numbers in an empty column preceding the street name plus removing the quotation marks and area information with it's dash.
| 1 | 1 |5701-5799|Rutgers St | 105 |07/19/05|
| 2 | 1 | 101-99|Gold Blvd | 98 |07/19/05|
| 3 | 1 | 2-38|Small Ct | 75 |07/19/05|
The final result appearing in columns C and D
If not possible at least the extraction of the street name for column D. Thanks in advance for reading this thread.
Mr Ed