CODEWITHSUNDEEP
splitgoogle-sheets
Rustam Apay
Rustam Apay

Reputation: 591

How to combine splitted data from one cell in another one in Google SpreadSheets

I have a cell with multiple rows (Alt+Enter), and I want split it and use all split single data in another cell.

enter image description here

Is there a way to do this?

Upvotes: 1

Views: 43

Answers (1)

user3717023
user3717023

Reputation:

Apply join after splitting, with the first argument being the text you want in between types. Concatenate with the text that should be at the beginning and the end. 

="[[Category: " & join("]]" & char(10) & "[[Category: ", split(A2,char(10))) & "]]"

For more complex text processing, consider regexreplace.

Upvotes: 1

Related Questions