Text Formatting Guidance
Status: Closed · Asked by Omni Digital on · 0 views
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
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.