How to populate a version # change to a text sentence

Solved/Closed
gamesactual Posts 3 Registration date Sunday September 20, 2015 Status Member Last seen September 21, 2015 - Sep 20, 2015 at 01:25 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 21, 2015 at 08:18 PM
Hello,

Using Excel 2013

What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those cells there are sentences that include the version #. Right now when I want to update the version number from 2015.09.19.1950 to say 2015.09.19.2110 I have to manually go to each cell that contains the sentence where the version # is included.

What I want to do is have a column called 'Versions' and when I change the version in that single column it will update the version number within the sentences in each cell I tag within that row.

So example. The new version was 2015.09.19.2110

And in one of my columns call [version] within the cell the words would be:

MySoftwareName :: Version - 2015.09.19.2110

In another column(many columns per row) called [short_description] within that cell are these words and the version should change automatically when I key it into the 'Versions' column...

This is the short description of MySoftware and its current version is 2015.09.19.2110, to download click here

I can go on, but there are 4 columns where I need to tag within each of the cells sentence of wording that this is the 'version#' that will change automatically when I key it in the version column. So I key it once and it populates it into the text sentences I have tagged for it to be in sync.

Thank you deeply for anyone who has experienced this before and can share the how-to :D

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 20, 2015 at 11:50 AM
gamesactual, Good afternoon.

You can use a CONCATENATE function to this question.

Suppose:

A1 --> YOUR TEXT
B1 --> Version # --> 2015.12.34.4444

Try to use:
A1 -->
="This is the short description of MySoftware and its current version is " & B1 & ", to download click here"

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
gamesactual Posts 3 Registration date Sunday September 20, 2015 Status Member Last seen September 21, 2015
Sep 21, 2015 at 06:01 PM
Thanks Belo,

That looks perfect. I'll need to research this more. The only issue I see is the quote marks. No quotes in my cells. However I will test as soon as I can and report back.
Thank you for taking the time to answer. Salute to you in Brasil
0
gamesactual Posts 3 Registration date Sunday September 20, 2015 Status Member Last seen September 21, 2015
Sep 21, 2015 at 06:59 PM
That works perfect Belo. Since its a function it will only show the results in the cell, no quotes, it's perfect. Thanx again!

For others I found more details here too
https://support.microsoft.com/en-us/office/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d?ui=en-us&rs=en-us&ad=us
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 21, 2015 at 08:18 PM
gamesactual, Good evening.

I feel happy to help you.

Have a nice day!

--
Belo Horizonte, Brasil.
Marcílio Lobão
0