Adding bullets to multiple lines within one cell after data exists already

[FuriousD]

I received a file with a lot of data in line items but want them cleaned up into bullets. Each bullet already exists as a separate line, but is there a way to have each separate line begin with a bullet more easily than to manually insert them?

I have 280 rows and several columns that need this applied so prefer it be logic.

TIA

	A (how the data is today)​	B (how I want it to look)​
Row 1	Line 1 Line 2 Line 3 Line 4	Line 1 Line 2 Line 3 Line 4

 

[kweaver]

How about:

Book1
	A	B
1	This is line 1 And next line Third Line	• This is line 1 • And next line • Third Line
2	first line Second line	• first line • Second line
Sheet4

Cell Formulas
Range	Formula
B1:B2	B1	=CHAR(149)&" "&SUBSTITUTE(A1,CHAR(10),CHAR(10)&CHAR(149)&" ")

 

[FuriousD]

Thank you! This worked perfectly

How about:

Book1
	A	B
1	This is line 1 And next line Third Line	• This is line 1 • And next line • Third Line
2	first line Second line	• first line • Second line
Sheet4

Cell Formulas
Range	Formula
B1:B2	B1	=CHAR(149)&" "&SUBSTITUTE(A1,CHAR(10),CHAR(10)&CHAR(149)&" ")

 

[kweaver]

That's great...glad to hear. Please mark it solved.