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...
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.- Thanks for this link. I can make it work with some of the text but I get stuck when I need to extract from midway through. Also I don't know how to create a macro or button and apply this multiple times ? I would be happy to Paypal you to do this for me ?