N
N
Nik Master2022-02-22 21:34:40
excel
Nik Master, 2022-02-22 21:34:40

How to add text from one cell to another between characters?

Hello. There is a markup in excel, the same throughout the column. In another column, the text throughout the column is different. How to transfer text from a column with different text to a column with repeating text between the desired characters? I know that there is a formula, but I can not find the right one in any way.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
datka, 2022-02-23
@datka

=CONCATENATE("<div class='gh'>"; B1 ; "</div>")
Where B1 is the cell with your text

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question