r/excel

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.

I’m looking to utilize excel more in my job and school. I have a good understanding of the basics and all the basic formulas, so what should my next step be?

Data analysis, power pivots or queries, VBA, etc.?

I teach Excel and was wondering if there exists a possibility to create self grading Excel assignments?