Forum Discussion
excel split text into 1 column
do this for all your columns:
When you're done
Do a power query on each of the two columns in the image above, load as a connection
when you have done all the queries on all letters, do an append query on all the queries so they'll all be in one column. Keep in mind that excel has a limit of 1 million rows so you might have to break them up by alpha/numeric segments.
cheers
Yea_So yes! im sorry im new to this its my first post how would i do that ?
is there some user information i would need from you?
i believe ive already attached the file to the post also
thanks
Here is an example of why you need to share your workbook:
https://1drv.ms/x/s!AiUZUhiQtF3FguNrlX7MZigdiFbXYA?e=ibFH2o
If you look at the formula in column B
=IF(D2<0,"",IFERROR(RIGHT([@[LOAD DESCRIPTION]],LEN([@[LOAD DESCRIPTION]])-(FIND(" ",[@[LOAD DESCRIPTION]],D2+5))),RIGHT([@[LOAD DESCRIPTION]],LEN([@[LOAD DESCRIPTION]])-(FIND(" ",[@[LOAD DESCRIPTION]],D2+2)))))&IF(ISNUMBER(OFFSET(ParseTable[@SUM],0,8)),LEFT([@[LOAD DESCRIPTION]],FIND(" ",[@[LOAD DESCRIPTION]])-1),IFERROR(LEFT([@[LOAD DESCRIPTION]],D2),""))it parses the text in column A
the consistency of the formula is very dependent on the order and the consistency of the length of the sentences on each row and how many words to parse in each row