Text Formatting Guidance

[yang_yang74]

Apparently, I tried to pass the data from Meta's lead form to Google Sheets, but the spaces in the text are not showing correctly. Instead, they are replaced with underscores (_). This is what the Google Sheet is populated with:

• 0_years
• 3-5_years
• 1-2_years
• more_than_5_years

This format appears inside the Google Sheets columns, and I’m trying to fix it. My question is: Can we use Pabbly Text Formatter to change the format , switching the (_) to space? If yes, how can we implement it?

Please help! Thankyou

 

[Deleted member 15445]

Hey @yang_yang74

Yes, you can surely do that with the help of Text Formatter "Replace Text" action step. Kindly replace "_" with "{{space}}". Please refer to the image below,

Let us know if it works for you.