Macro or app script for autoreplace pasted data

Question

Is there are any chance to have such script, that perform replace of "pasted data" to any cell of column B to "abc"+"pasted data"?

I think that in your situation, OnEdit simple trigger can be used. And, I thought that these threads might be useful for understanding for creating a script. https://stackoverflow.com/q/37286851 https://stackoverflow.com/q/58378575 https://stackoverflow.com/a/38820952 — Tanaike, Aug 29 '22 at 07:04

score 0 · Answer 1 · answered Aug 29 '22 at 10:34

0

while there is a script for what you request until you get one try this in C1 cell:

=ARRAYFORMULA(IF(ISBLANK(B:B);;"""abc""+"""&B:B&""""))

answered Aug 29 '22 at 10:34

player0

1 Answers1