How to populate a version # change to a text sentence [Solved/Closed]

Report
Posts
3
Registration date
Sunday September 20, 2015
Status
Member
Last seen
September 21, 2015
-
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
-
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 replies

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
3
Registration date
Sunday September 20, 2015
Status
Member
Last seen
September 21, 2015

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
Posts
3
Registration date
Sunday September 20, 2015
Status
Member
Last seen
September 21, 2015

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.office.com/en-us/article/CONCATENATE-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
gamesactual, Good evening.

I feel happy to help you.

Have a nice day!

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