We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

asked 2014-07-21 18:36:31 +0200

astrofluff gravatar image

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!!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-01 01:12:26.766921

2 Answers

Sort by » oldest newest most voted

answered 2014-07-21 19:43:41 +0200

Lupp gravatar image

updated 2014-07-21 20:00:09 +0200

If you really want to get it in a single cell:

Be "Davidson, Lauren O." (without the QMs) in A11 (and the other names from there downward in column A) and the formula

=MID(A11;FIND(",";A11)+2;1024)&" "&LEFT(A11;FIND(",";A11)-1)

in another cell (best B11) and filled downward in its column as needed, you'll get what you want if the syntax you described by giving an example is "complete" enough. Names that do not contain exactly one occurrence of a comma followed by a single space or names containing trailing spaces will cause complications.

I would prefer using (a) helper(s) column(s).

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-07-21 18:36:31 +0200

Seen: 4,118 times

Last updated: Jul 21 '14