You can execute the proc into a temp table, then use that to parse the string.
Drop procedure if exists sp_test
go
create proc sp_test as select 'string1, string2, string3' n
drop table if exists #test
create table #test (N varchar(max))
insert into #test
execute sp_test
go
select * from #test