Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Batch cells editing

Topic Labels: Automations
243 3
Showing results for 
Search instead for 
Did you mean: 

Hello there :slightly_smiling_face:

First, I’m sorry if it’s not the good category, I wasn’t sure about where to post that …
I’m wondering if it’s possible to batch edit cells:

  • adding a numbered suffix to the current text of the cells (for example, adding numbering to myObject to get different lines with myObject1, myObject2, myObject3 …)
  • batch replacing terms in the selected cells (for example, if cells are filled with alpha.beta.myObject, replacing alpha by delta)

More globaly, I’m looking for ways to ease the edition of multiple cells at once :winking_face:

Thanks a lot for any help you could provide.

Best regards.

Nicolas Caplat

3 Replies 3

I usually just end up making a new formula field to apply the changes, and then pasting the formula field’s values into the original field

e.g. for the numbered suffix thing, I would make a new Autonumber field, followed by a formula field with the formula {FIELD} & {Autonumber}, and then paste the resulting field’s values over

Or for the replacement, just doing a new formula field with Substitute()

Good morning :slightly_smiling_face:

Thank you @ScottWorld @Adam_TheTimeSavingCo , both seem to be interesting solutions … though I was hoping for very simple procedure :winking_face: I will test your suggestions for sure !

Thanks again,


Nicolas Caplat