Separate sentences in Google Sheets

[Thms_dbs]

Hello, my question is how to seperate a sentence that includes many commas for example
item1,item2,item3

what i want to do is they should look like item1 but in the same cell like in A1
item2
item3
in the picture the first line that includes item come from API but it comes in as 1 sentence and i need them like in the second cell which i made to explain

 

[StephenCrump]

Welcome to the Forum!

Try: =SUBSTITUTE(A1,",",","&CHAR(10))

(with the cell formatted to wrap text)

 

[Thms_dbs]

Welcome to the Forum!

Try: =SUBSTITUTE(A1,",",","&CHAR(10))

(with the cell formatted to wrap text)

it says Formula parse error.

 

[RoryA]

Perhaps you normally use semicolons to separate arguments in Excel?

=SUBSTITUTE(A1;",";","&CHAR(10))

 

[StephenCrump]

... or are you perhaps using Google Sheets?

 

[Thms_dbs]

Perhaps you normally use semicolons to separate arguments in Excel?

=SUBSTITUTE(A1;",";","&CHAR(10))

yea i am using google sheets and this one works so is it possible to integrate this to whole column at ones i mean if i click just A it just chooses A1

 

[Fuji]

1) Select the range and Ctrl + H (Find and Replace)
2) Enter a comma , in [Find what]
3) In [Replace with], enter a comma , and Ctrl + 0010 (0010 MUST be entered from Number pad, not from the top of the keyboard)
4) click on [Replace All]

Does this help?

PS;
Not sure if this works for Google Sheets.

 

[Thms_dbs]

1) Select the range and Ctrl + H (Find and Replace)
2) Enter a comma , in [Find what]
3) In [Replace with], enter a comma , and Ctrl + 0010 (0010 MUST be entered from Number pad, not from the top of the keyboard)
4) click on [Replace All]

Does this help?

PS;
Not sure if this works for Google Sheets.

(and Ctrl + 0010) this part not showing anything maybe because of google sheets

 

[Fuji]

It is a code for Carriage Return, so not visible.

From web

You can also quickly identify line breaks with the Find and Replace tool in Google Docs. To do this, navigate to Edit > Find and Replace and tick the Use regular expressions checkbox. To find hard returns, you'll need to search for the syntax reference \n;

 

[Thms_dbs]

It is a code for Carriage Return, so not visible.

From web

You can also quickly identify line breaks with the Find and Replace tool in Google Docs. To do this, navigate to Edit > Find and Replace and tick the Use regular expressions checkbox. To find hard returns, you'll need to search for the syntax reference \n;

still didnt work, do you know how can i apply a format to all cells ?