Skip to Content (Press Enter)
UserImage.jpg
AC
2366Views
5Comments
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 .

1
0
02 Feb 2018
Copy Link
2020-10-02 21-47-41
Samuel Nunes Marques
Solution

Hi,

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

Regards,
Samuel

4
0
02 Feb 2018
Copy Link
UserImage.jpg
AC

Thanks Samuel  its worked..

0
0
04 Feb 2018
Copy Link
2018-11-07 10-57-20
Carolina Bessa

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)

2
0
06 Nov 2020
Copy Link
2020-04-15 19-07-26
Eduardo Rodrigues

Hi Carolina,

Thanks for sharing this option more

0
0
06 Nov 2020
Copy Link
UserImage.jpg
Rodrigo Paula

Thanks Carolina! You've saved me :)

1
0
08 May 2025
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.