Sorry, I was unaware of this cross post rule which https://www.excelguru.ca/forum…t-text-to-columns-formula also notified me of.
I very rarely turn to message boards or forums and generally not until I totally exhaust other avenues and reading to understand or if I am on a time crunch and spending too much time trying to figure something out.
Back to the question at hand. The text to column wizard will not work for this application. Looking to write a formula that with perform the text to column as the selections are made.