It is very common for formulas in your tables to become long. Or you might find yourself needing to write a particularly complex formula that you are struggling to make work. This is where formula segmenting can really begin to help.

Segmenting your formulas across columns has the following benefits:

Actually faster for your docs and tables! Segmenting your formulas is where you write formulas in small chunks in separate columns, rather than writing one large formula in a single column Take for example the table below.

A non-segmented formula

The formula that is written in the gray column is a longer and harder to understand and de-bug formula that pulls all the vowels out of the first half of a persons email.

A segmented formula

The blue columns demonstrate how to segment this same formula across multiple columns. Segmenting in this way makes the formula easier to understand, write, de-bug, and makes your doc faster in the long run

All vowels in first half of an email address

# Ready to master Coda yourself?

Join the Coda School today