Need to remove extra character

[Harini1100]

Hello Team,

Kindly help to remove the additional * from the source data, below is the sample file,

 

[FormR]

Hi, one option you could try (this assumes that the "Λ" character will never appear in the source text):

Book1
	A	B
1	adsd sda sa ***** sadsa bfd*asd******dsad **s dss d	adsd sda sa * sadsa bfd*asd*dsad *s dss d
Sheet1

Cell Formulas
Range	Formula
B1	B1	=SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(A1," ","Λ"),"*"," "))," ","*"),"Λ"," ")

 

[Harini1100]

It's Perfect, Multitude Thanks

 

[Scott Huish]

If you are using Excel 365, I think this would work as well:
=TEXTJOIN("*",TRUE,TEXTSPLIT(A1,"*"))