Posts by Elso1959

Hi Alan

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.

Thank you

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

Hello

Please assist with a split text to columns formula

I seem to be getting lost in the syntax of how to break this sort of text string to columns.

Best described by looking at the attached xlsx file.

text split test.xlsx

I am using Excel 2013

Thank you

Elso