0

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

For example: "ABCD [45] - City"

Result: "[45] ABCD - City"

Vianne
  • 548
  • 1
  • 10
  • 31

1 Answers1

1

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!

ngulam
  • 995
  • 1
  • 6
  • 11