SQL Server 2014 :: Export Data Without HTML Formatting

I need to export some Database data into a text file. My Query looks like this:

SELECT Category1, Category2, Category3
FROM dbo.tbl1
WHERE Category1 = 'JP-4'
AND Category2> 4;

This works fine to get the data, however there is some html formatting in the table entries such as

`<p>,</p>,
,</br>` etc.

So ideally I need to remove those when exporting the data to the text file. I've tried to do it with a simple replace query but that didn't work. I've also got an issue with line splits and would need to remove the ( ).

The Data format is something like this:

Category1: JP-4
Category2: 4
Category3:<p>Neque porro quisquam est qui dolorem ipsum quia dolor</p> <p>amet, consectetur, adipisci velit</p>
Category4:<p>Neque porro quisquam est qui dolorem ipsum quia dolor</p>

I got it to work like this with the replace function:

SELECT REPLACE(REPLACE("PHOTOGRAPHS",'<p>',''),'</p>','')
FROM dbo.khia_tbl
WHERE Category1= 'JP-4'
AND Category2> 4;

But the issue is that I've got 15 columns in total and that I need to do it for several different tags for each column so
,
</br>,

as well as "" and different spaces so that would be a lot and I thought there must be a better/more efficient way of doing it...