I'm not from programing background. But as a civil engineer, I design several templates for structure design calculations. Recently I was looking for a way to invert the text for some reason, and chat GPT provided function with indirect function. Wanted to understand the logic behind its function, so that I maybe able to better adopt it rather than just copying it.
Chat GPT came up with this (for reversing text of last 5 characters only, from text string)
=TEXTJOIN("", TRUE, MID(RIGHT(A1, 5), 6-ROW(INDIRECT("1:5")), 1))
I tried to google and somehow i'm unable to corelate the function to its output...
Thanks in advance.