Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

In Calc, is there a way to reverse the order of text in a cell?

There has to be a way to do this, but as a graphic designer, spreadsheet programs are not my forte.

I have 500+ cells of names written like this: "Davidson, Lauren O." and I need them to be "Lauren O. Davidson". Basically, everything left of the comma needs to be moved to the end of the string.

It doesn't even have to be kept in a LibreOffice Calc format - I just need to copy and paste the text into InDesign.

Thank you!!