Current Events > Is there an Excel function or website where you can insert values into a text?

(+) Yeah! (+)

Hard to explain in a topic title. For example:

I have X bones in Y jar.

Where you can mark X and Y as variables, while leaving the rest as just text. So then youd be able to easily change them as needed. At the moment Im doing something like this, but I have to manually change X and Y, as well as a W and Z. Which doesnt sound too bad, but theres a lot of it to do.

Edit: I should note that I cant pull the numbers from a spreadsheet. If I could, I might be able to figure something out, but as is it Im drawing a blank.

Yes. In vanilla excel. An easy concatenate function.

Naysaspace posted...

Yes. In vanilla excel. An easy concatenate function.

That might be what Im looking for, thanks. I was almost certain there was something like that, but searching just came up with a bunch of irrelevant stuff. Ill be sure to check it out soon.

so fun fact: concatenate, as a function, can be replaced by simple syntax.

for example

="I have "&A1&" bones in "&A2&" The Jar."

A1 and A2 are your variable cells where you change whatever you need to. Sub in whatever cells/data you choose.

Also, feel free to DM me for free excel advise. i normally charge $ for this, but for a ceman, first one is free.