CODEWITHSUNDEEP
excel
John Threepwood
John Threepwood

Reputation: 16143

How to edit multiple cells in Excel at once?

I want to edit multiple cells in Excel at once.

Example: Put a certain string in front of the content of each cell.

How can I achieve this? Maybe with regular expressions and 'serach & replace'?

Upvotes: 6

Views: 44302

Answers (3)

pnuts
pnuts

Reputation: 59485

Relying on "a certain string" to imply this is always or usually the same string, then an 'appearances only' solution might possibly be of interest. ie format the cells to include the relevant text. Either "certain text "@ or "certain text "#:

SO18631571 example

Upvotes: 0

bendataclear
bendataclear

Reputation: 3850

I need to do this regularly and the least messy way I have found is copying into Sublime Text and editing there as it supports editing multiple lines simultaniously.

Link to Sublime Text Website

Upvotes: 4

Tomas Greif
Tomas Greif

Reputation: 22663

You can try to find some add-in, e.g. RegEx Find/Replace or work with some existing UDFs, e.g. here

Upvotes: 0

Related Questions