Forum Discussion
Issue with Separating data
Good morning, I have an issue with data that we export from our Sage accounts into Excel. It comes into Excel from a single continuous text box entry in Sage and it is a description of a rubber h...
I'm not clear on what you're looking to do for the first column but this may do it for you:
=LET(split,TEXTSPLIT(A1,":",CHAR(10),,,""),WRAPCOLS(TOCOL(split),2))
- Hi there, thanks for this !
Yes, I wasn't very clear - Column 1 should be Hose Type and in this case, that type is "Steam Delivery Hose"
D
