So I have the goal of sending a list of all rows in a google sheet that meet a certain condition as a message in Slack,
So far all is good except for one small formatting annoyance
“COL$B: This is a message
COL$C: This is a URL
id: 51
row: 51
COL$B: This is a message
COL$C: This is a URL
id: 103
row: 103”
As you can see the COL$ and the id and row are unnecessary for the message, is there a way in the find replace to use wildcards so I can remove the COL$[character] and the id and row lines?
Best answer by ikbelkirasan
View original