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...
if possible，share some dummy data and expected result。
peiyezhu Hi, see attached. The text all in one column needs to be separated out into columns headed as per the bold text in my post.
if possible,share excel file rather than pdf.
In fact,I can not get what you want excatly by now because the pdf did not show all datas completely.
Below is a reference to split columns.
hope helpful.
https://techcommunity.microsoft.com/t5/excel/text-after-delimiter/m-p/3832003
- https://www.howtogeek.com/825231/how-to-split-and-extract-text-in-microsoft-excel/#autotoc_anchor_2
try text split or smart fill.