Removing Space between Names

Declare @temp table(Name varchar(50))
insert into @temp values
('Raja Rao'),('Arul     Pandi'),('Mahesh          Babu'),('Suresh             Kumar')

Select Name [Name with Space]
	,Substring(Name,0,charindex(' ',Name))+
		LTRIM(Substring(Name,charindex(' ',Name)+1,LEN(Name)-charindex(' ',Name))) [Name without Space]
from @temp