911
Views
4
Comments
Solved
Remove Space between the string
Question

Hi ,


I want to remove Space between string  how we can do it  for example i have string -

Country Details , i  want to change to >> countryDetails 

how we can do it please suggest .

Rank: #428
Solution

Hi,

I think you can use the Replace Built-in Function to do that. Something like Replace("Country Details", " ","").

Regards,
Samuel

Rank: #792

Thanks Samuel  its worked..

Rank: #653

Just additionally to this topic, recently I got the issue that Replace(" ","") and Trim() were not having effect on data coming from Excel so I had to add the other replaces:

Replace(Text, Chr(160), Chr(32))
Replace(Text, Chr(9), Chr(32))
And then I did Trim(Text)

Hi Carolina,

Thanks for sharing this option more