Hi
I'm trying to create a paragraph of text where at certain points a number or word is inserted depending on the value of a different cell. So for example, I'd want it to look like this:
"I want to have a string of text but part way through *A1* would be inserted which could either be a number or a word"
At the moment I'm using the concatenate function =concatenate(A2,A1,A3) with the following cells:
A1 - The value/word I want inserting
A2 - "I want to have a string of text put part way through "
A3 - " would be inserted which could either be a number or a word"
That works perfectly fine. However, the paragraph (eventually it will be a number of paragraphs) is quite long and has 10/15 different inputs so I'm concatenating a large number of cells. The user has to have the ability to edit the paragraph which is pretty difficult when its spread across a number of cells and makes no sense because there are random words/numbers missing.
I thought about having the text all in one cell with example entries such as:
A1 - The value/word I want inserting
A2 - "I want to have a string of text but part way through [value] would be inserted which could either be a number of a word"
I'd then use the concatenate function in conjunction with the LEFT and RIGHT functions so I could split it out before concatenating it again. The trouble with that is if they edit the text by adding/removing characters then it would split it up in the incorrect places.
I wondered if there was a way of splitting up the text based on where a certain identifier is. So you would take the string of characters up to [value] and then the string of characters after [value]? So decomposing it based on where [value] is and then putting it back together with concatenate.
Either that or some other method that I'm not aware of? The idea is for it to be as user friendly as possible.
Thanks!![]()
Bookmarks