Suddenly need to append a text label to a whole lot of spreadsheet data? You don’t have to do so manually — it’s pretty easy to add text with a simple formula in your spreadsheet app of choice.
How Do I? covers the basics, because we’ve all got to start somewhere.
Don’t want video? That’s fine, the process is pretty simple.
Support Alex Reviews Tech
Alex Reviews Tech is an independent, ethically run tech reviews site, and it needs your help to keep going. Support independent media by becoming a sponsor through Patreon, Ko-Fi or Paypal! (Spoiler: If enough folks do this, I'll be able to get rid of the ads)
Donate via PayPal
Find out more about how you can support Alex Reviews Tech here.
Let’s say you have a column of text and you realise that you forgot to add in a crucial detail. In the example video above, I have a row of data reading “Frog” and I want to add “Green Tree” to the front of it. Here’s how to do so.
- Select a cell without data in in.
- Add a formula by typing =concat(“Green Tree “,
- After the comma, click into the cell that has the text you want to add text to — in my example above it was cell A2, but yours may vary.
- That should add to your formula, so you end up with the formula =concat(“Green Tree “,A2. Add a close bracket to finish the formula and hit enter.
- You should end up with a cell that now reads “Green Tree Frog”… but it’s not where you want those words to be. Not to worry! Firstly, copy (by dragging down is the easiest) that formula down or across to cover the number of cells you want to append to. Then copy those cells (CTRL+C on the keyboard).
- Select your original cells, but don’t paste (CTRL+V).
- Choose Edit/Paste Special and choose “Values”. That should then copy “Green Tree Frog” over each of those cells. You can then delete the original formula cells (which by now will read “Green Tree Green Tree Frog”, because it’s still reading from those original cells), and the job is done!
Was this useful to you? Support independent media by dropping a dollar or two in the tip jar below!
Apple iPhone 8 64GB 256GB - (Renewed)
$169.00 (as of February 17, 2025 18:36 GMT +11:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)Google Pixel 8a - 128GB Porcelain
$649.00 (as of February 17, 2025 18:36 GMT +11:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)iPhone 13 128GB
$599.00 (as of February 17, 2025 18:36 GMT +11:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)Samsung Galaxy S24 Ultra AI Smartphone, 12GB RAM 256GB, Titanium Grey
$1,486.00 (as of February 17, 2025 18:36 GMT +11:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)SAMSUNG Galaxy A55 5G smartphone 128 GB Lime
$489.37 (as of February 17, 2025 18:36 GMT +11:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)Was this useful to you?
If so, please consider becoming a Patreon, Ko-Fi or Paypal supporter Alex here (again).
I feel strongly that independent tech media is a needed resource to help people make smarter tech buying decisions -- and I also very much like to help people use that tech once they've got it.
This is what I do, but I can't do it without your support.
If this article has helped you out (or you've just enjoyed it), please consider helping support what I do by becoming a sponsor today!
Become an ART Patron
Donate via PayPal
Find out more about how you can support Alex Reviews Tech here.