Oct 25 2022 06:58 AM
Hello All,
I am new space and looking to automate one task where I need to replace values in between texts which is coming from different sheet. I managed to update values between sheets using "vlookup" function , but here , my requirement to pick values among texts and replace from different sheet.
In given below text , I want to select values from other sheet and paste into the sheet which is in between "double quotes
Regards
Oct 25 2022 07:11 AM
Hi @AlokBeheria,
if I understand you right, you want to mix static text with dynamic text. If that's the case, you have to enter the static text starting with = sign and double quotes. And then you can concatenate it with any type of formula, cell reference etc. by using the ampersand sign &
Here is one example that just pulls another text from cell A1 in Sheet2:
="Hi L3 Support, we have received confirmation… This requirement is for "&Sheet2!A1&" after migration. DDB to update…."
Oct 25 2022 09:08 AM
Oct 25 2022 11:36 PM
Oct 26 2022 06:52 AM
Hi @AlokBeheria
I do not understand why changes are not reflected immediately on your side. As it is just a cell reference to another sheet, any changes there should be visible right away in the formula cell.
Concerning text alignment and maintaining the static texts, I see your point. To a certain extent, you can deal with it by entering all static texts in separate cells. And then concatenate them in one formula cell.
=A1&CHAR(10)&A2&CHAR(10)&A3&" "&Sheet2!A1&" "&A4&CHAR(10)&A5
The CHAR(10) inserts a line break. Please note that in order to get these line breaks working, you need to adjust the column with, so it's wide enough. And you have to activate the "Wrap text" functionality:
I admit this is far from perfect, but it's the best solution I can offer.
Oct 27 2022 10:03 AM