Replace placeholder text in Google Sheets Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!Google sheets isformula() equivalent?Dynamic data validation sheet name for sheet duplicationUsing A Cell To Reference The Name Of Sheet In A Formula For Google SheetsReplace text in a Google Sheet and maintaining formulasRemove HTML In Google Sheets CellsTRANSPOSING: How to copy a cell value into the 'Sheet' part of formulaShare Google Sheet, but keep script privateIFERROR and ARRAY_CONSTRAIN formulas in Google sheetsGoogle Sheets - Include Sheet Name in formula depending on string inputGoogle Apps Script for Multiple Find and Replace in ONE COLUMN in Google Sheets
Does classifying an integer as a discrete log require it be part of a multiplicative group?
How to tell that you are a giant?
Can an alien society believe that their star system is the universe?
Using et al. for a last / senior author rather than for a first author
How to Make a Beautiful Stacked 3D Plot
Can anything be seen from the center of the Boötes void? How dark would it be?
Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?
How to find all the available tools in mac terminal?
Fantasy story; one type of magic grows in power with use, but the more powerful they are, they more they are drawn to travel to their source
How could we fake a moon landing now?
Is CEO the profession with the most psychopaths?
Do wooden building fires get hotter than 600°C?
How do pianists reach extremely loud dynamics?
Do jazz musicians improvise on the parent scale in addition to the chord-scales?
How to react to hostile behavior from a senior developer?
How would a mousetrap for use in space work?
What would be the ideal power source for a cybernetic eye?
What does "lightly crushed" mean for cardamon pods?
2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?
What is homebrew?
Where are Serre’s lectures at Collège de France to be found?
Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?
Denied boarding although I have proper visa and documentation. To whom should I make a complaint?
Why aren't air breathing engines used as small first stages
Replace placeholder text in Google Sheets
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!Google sheets isformula() equivalent?Dynamic data validation sheet name for sheet duplicationUsing A Cell To Reference The Name Of Sheet In A Formula For Google SheetsReplace text in a Google Sheet and maintaining formulasRemove HTML In Google Sheets CellsTRANSPOSING: How to copy a cell value into the 'Sheet' part of formulaShare Google Sheet, but keep script privateIFERROR and ARRAY_CONSTRAIN formulas in Google sheetsGoogle Sheets - Include Sheet Name in formula depending on string inputGoogle Apps Script for Multiple Find and Replace in ONE COLUMN in Google Sheets
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
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?
google-sheets
edited Mar 8 at 19:00
player0
7,76641332
asked Mar 8 at 18:41
StephenMeehanStephenMeehan
63021021
add a comment |
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?
google-sheets
edited Mar 8 at 19:00
player0
7,76641332
asked Mar 8 at 18:41
StephenMeehanStephenMeehan
63021021
add a comment |
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?
google-sheets
edited Mar 8 at 19:00
player0
7,76641332
asked Mar 8 at 18:41
StephenMeehanStephenMeehan
63021021
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?
google-sheets
google-sheets
edited Mar 8 at 19:00
player0
7,76641332
asked Mar 8 at 18:41
StephenMeehanStephenMeehan
63021021
edited Mar 8 at 19:00
player0
7,76641332
asked Mar 8 at 18:41
StephenMeehanStephenMeehan
63021021
edited Mar 8 at 19:00
player0
7,76641332
edited Mar 8 at 19:00
player0
7,76641332
edited Mar 8 at 19:00
player0
7,76641332
7,76641332
asked Mar 8 at 18:41
StephenMeehanStephenMeehan
63021021
asked Mar 8 at 18:41
StephenMeehanStephenMeehan
63021021
asked Mar 8 at 18:41
StephenMeehanStephenMeehan
63021021
63021021
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
you can either use CTRL + H:
or you can hardcode all instances with formulas referencing the B1:
="Homepage | Journey | "&B1
answered Mar 8 at 18:59
player0player0
7,76641332
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55069168%2freplace-placeholder-text-in-google-sheets%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
you can either use CTRL + H:
or you can hardcode all instances with formulas referencing the B1:
="Homepage | Journey | "&B1
answered Mar 8 at 18:59
player0player0
7,76641332
add a comment |
you can either use CTRL + H:
or you can hardcode all instances with formulas referencing the B1:
="Homepage | Journey | "&B1
answered Mar 8 at 18:59
player0player0
7,76641332
add a comment |
you can either use CTRL + H:
or you can hardcode all instances with formulas referencing the B1:
="Homepage | Journey | "&B1
answered Mar 8 at 18:59
player0player0
7,76641332
you can either use CTRL + H:
or you can hardcode all instances with formulas referencing the B1:
="Homepage | Journey | "&B1
answered Mar 8 at 18:59
player0player0
7,76641332
answered Mar 8 at 18:59
player0player0
7,76641332
answered Mar 8 at 18:59
player0player0
7,76641332
answered Mar 8 at 18:59
player0player0
7,76641332
7,76641332
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55069168%2freplace-placeholder-text-in-google-sheets%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
