CODEWITHSUNDEEP
google-sheets
StephenMeehan
StephenMeehan

Reputation: 1113

Replace placeholder text in Google Sheets

What would be the best way to replace [placeholder] text in Google Sheets?

I've created a demo Google Sheet here.

I'd like to be able to use the word 'Coke' in B1 and replace all the [Brand-Name] placeholders.

Ideally, I'd like to be able to just type into a new cell (see B6) and not have to worry about messing up a formula.

Is there a way to do this?

Upvotes: 1

Views: 7285

Answers (1)

player0
player0

Reputation: 1

you can either use CTRL + H:

0

or you can hardcode all instances with formulas referencing the B1:

="Homepage | Journey | "&B1

0

Upvotes: 1

Related Questions