# Find & replace text in a formula field **URL:** \ **Category:** Tips & Tricks\ **Created:** [February 14, 2023, 5:16pm UTC](https://air.tableforums.com/t/find-replace-text-in-a-formula-field/249 "2023-02-14T17:16:14Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Databaser](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/databaser/32/11_2.png) [@Databaser](https://air.tableforums.com/u/Databaser)\ **Post date:** [February 14, 2023, 5:16pm UTC](https://air.tableforums.com/t/find-replace-text-in-a-formula-field/249/1 "2023-02-14T17:16:14Z")
WAIT… you can CTRL + F to search or search & replace IN a formula box?! 😱😲💡 ![image](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/a6e5ab3bb7d33969a87e516475c8b1f5de03a738.png) Never really needed it, so only discovered this now 🤷‍♂️ ---
**Author:** ![Kuovonne](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/kuovonne/32/17_2.png) [@Kuovonne](https://air.tableforums.com/u/Kuovonne)\ **Post date:** [February 14, 2023, 7:02pm UTC](https://air.tableforums.com/t/find-replace-text-in-a-formula-field/249/2 "2023-02-14T19:02:37Z")
Yup. Lots of fun stuff you can do in the formula editor. I think that it is built on the same Monaco platform that the scripting editor uses and has lots of nifty featurs - indent and outdent multiple lines with tab and shift+tab (as long as autocomplete behaves) - get multiple cursors on consecutive lines with using ctrl+alt+arrow - collapse and expand sections using arrows in the left margin ---
**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\ **Post date:** [February 15, 2023, 12:51am UTC](https://air.tableforums.com/t/find-replace-text-in-a-formula-field/249/3 "2023-02-15T00:51:01Z")
> [@Databaser](#): > > WAIT… you can CTRL + F to search or search & replace IN a formula box?! 😱😲💡 Oh wow, that’s cool! I don’t think i noticed that before! > [@Kuovonne](#): > > - get multiple cursors on consecutive lines with using ctrl+alt+arrow Can you explain this one a bit more? I tried command-option-arrow on the Mac, but I couldn’t seem to get this to work. ---
**Author:** ![CodedWithGrace](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/codedwithgrace/32/174_2.png) [@CodedWithGrace](https://air.tableforums.com/u/CodedWithGrace)\ **Post date:** [February 15, 2023, 1:25am UTC](https://air.tableforums.com/t/find-replace-text-in-a-formula-field/249/4 "2023-02-15T01:25:38Z")
The upgrades to the built-in editor are great, but it still seems so clunky on my Mac… I just prefer VisualStudioCode when I’m working on complex formulas and at other times I’ll use good 'ol google sheet/Excel to build a formula ---
**Author:** ![Kuovonne](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/kuovonne/32/17_2.png) [@Kuovonne](https://air.tableforums.com/u/Kuovonne)\ **Post date:** [February 15, 2023, 2:12am UTC](https://air.tableforums.com/t/find-replace-text-in-a-formula-field/249/5 "2023-02-15T02:12:23Z")
> [@ScottWorld](#): > > Can you explain this one a bit more? I tried command-option-arrow on the Mac, but I couldn’t seem to get this to work. I hold down ctrl+alt and press the down arrow. An additional cursor appears on the line below so I have two cursors. Pressing the down arrow again gives me a third cursor on the line below. This is most useful when I want to type (or delete) the exact same thing in multiple lines. I do this more when typing JavaScript than when typing formulas. Not sure how to do this on a Mac. ---
**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\ **Post date:** [February 16, 2023, 4:06pm UTC](https://air.tableforums.com/t/find-replace-text-in-a-formula-field/249/6 "2023-02-16T16:06:16Z")
Oh cool, thanks! 😃 I figured this out on the Mac! On the Mac, you get this behavior by holding down the command & option keys together, and then pressing the down arrow. That’s wild! The ability to type (or delete) on multiple lines at the same time! How often do you find yourself using this feature? ---
**Author:** ![Kuovonne](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/kuovonne/32/17_2.png) [@Kuovonne](https://air.tableforums.com/u/Kuovonne)\ **Post date:** [February 16, 2023, 6:01pm UTC](https://air.tableforums.com/t/find-replace-text-in-a-formula-field/249/7 "2023-02-16T18:01:21Z")
> [@ScottWorld](#): > > How often do you find yourself using this feature? Not often in formulas. More often when writing scripts.