Batch cells editing

Hello there :slight_smile:

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 :wink:

Thanks a lot for any help you could provide.

Best regards.

Nicolas Caplat

The Batch Update extension can do some bulk actions.

1 Like

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()

2 Likes

Good morning :slight_smile:

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

Thanks again,

Regards.

Nicolas Caplat

1 Like