Home Creators Posts Import Register Favorites Logout

Content

Hello Members,

The training we have for this week that I have shared with you was about the Restaurant & Café Manager. If you have not seen it yet, you can view it right here on YouTube.

Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.

So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?

Please comment your ideas and feedback to any of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.

I am looking forward to hearing from you and thanks so much for your support.

Files

Comments

p l

Hi Randy, is there a way to parse the resulting text block that you are returning from chat gpt into individual lines. Makes it easier to use the result from the query.

Excel For Freelancers

Hi and yes, you can determine the character in your response that separates one line from the other, then use that character in the split function. For example if that character is a period "." and your entire response was in a variable called response you could write code using an array to separate it into different rows, something like Sub SplitRows() Dim Response as string, RespArr() as string, RespRow as long RespArr = Split(Response,".") For RespRow = LBound(RespArr) to UBound(RespArr) Sheet1.Range("A" & RespRow + 1).value = RespArr(RespRow) Next RespRow End Sub Something like that would work but i have not tested the code