CODEWITHSUNDEEP
excelexcel-formulaopenoffice.orgopenoffice-calcopenoffice-writer
Vianne
Vianne

Reputation: 578

Find and Move Text in OpenOffice Spreadsheet

Is it possible to search for a specific text in cells and move it?

For example: "ABCD [45] - City"

Result: "[45] ABCD - City"

Upvotes: 0

Views: 77

Answers (1)

ngulam
ngulam

Reputation: 1075

Of course you can.

It is possible by code, formulae or search/replace (using regex).

In your example you search for something in square brackets and put this finding in front.

A regular expression search here will be

search for: (.*)(\[.*\] )(.*)
replace by: $2$1$3

Don't forget to tick the option "regular expression" [Everything to search and replace with this is explained in online help: F1]

If you want code or formulae to have the task accomplished: ask more specific!

Upvotes: 1

Related Questions