0

How is it possible to scan for words and replace the whole cell via command?
I have the value

ASUS MB Z270 D4 1151

or

MB ASUS D4 Z270 1151

(word order doesn't matter)

And I want it to be:

Motherboard - Asus Z270 DDR4 LGA1151

I want to do the same for 1000+ values

L42
  • 18,912
  • 11
  • 41
  • 65
Kostas Kosmo
  • 43
  • 4
  • Possible duplicate of [How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops](https://stackoverflow.com/questions/22542834/how-to-use-regular-expressions-regex-in-microsoft-excel-both-in-cell-and-loops) – Ralph Dec 06 '17 at 09:34

1 Answers1

0

Hit CTRL + H for Search & Replace.

ashleedawg
  • 18,752
  • 7
  • 68
  • 96