Stack Text in Cells

[GMC The Macro Man]

Hi guys

I am trying to present the TEXT in Cell A2 to look like Cell A3. - Now before you all jump in.... I know it's ALT + Enter after each comma. My question is this. I have 300 Lines in Column A that look like Cell A2 and I don't want to have to go in to every individual cell and press ALT + Enter. I looked at Delimiter but that just wants top split it into separate columns.
Can anyone advise on a way to solve this.
Thanks in Advance

 

[Sufiyan97]

Try and do a wrap text

Excel Practice 05.22.2023.xlsx
	A	B
1	Text1, Text2, Text3, Text4	Text1, Text2, Text3, Text4
Sheet2

Cell Formulas
Range	Formula
B1	B1	=SUBSTITUTE(A1," ",CHAR(10))

 

[Peter_SSs]

• Select the column
• Invoke Find/Replace (Ctrl+H)
• Find what: Type a comma followed by a space
• Replace with: Type a comma followed by Ctrl+J
• Replace All
• Set Wrap Text for the column

 

[GMC The Macro Man]

Try and do a wrap text

Excel Practice 05.22.2023.xlsx
	A	B
1	Text1, Text2, Text3, Text4	Text1, Text2, Text3, Text4
Sheet2

Cell Formulas
Range	Formula
B1	B1	=SUBSTITUTE(A1," ",CHAR(10))

Thank you for taking the time to look at this and getting a resolve. It worked perfectly

 

[Sufiyan97]

You're welcome!
Have you tried a solution by Peter, it works without a formula.

 

[Peter_SSs]

Thank you for taking the time to look at this and getting a resolve. It worked perfectly

Does that mean there are no other spaces in your text apart from immediately after a comma?

If there is, look in column B below to see what the formula does.
If you are going to use a formula and not the direct method that I suggested above, then it would be safer to use the formula in column C below.

23 05 22.xlsm
	A	B	C
1	Text 1, Text 2, Text 3, Text 4	Text 1, Text 2, Text 3, Text 4	Text 1, Text 2, Text 3, Text 4
Wrap Text (2)

Cell Formulas
Range	Formula
B1	B1	=SUBSTITUTE(A1," ",CHAR(10))
C1	C1	=SUBSTITUTE(A1,", ",","&CHAR(10))

 

[GMC The Macro Man]

• Select the column
• Invoke Find/Replace (Ctrl+H)
• Find what: Type a comma followed by a space
• Replace with: Type a comma followed by Ctrl+J
• Replace All
• Set Wrap Text for the column

Thanks for taking the time to reply to my question. Your solution worked very similar to that of SUFIYAN97. Cheers

 

[Peter_SSs]

You're welcome.