REPLACE

REPLACE helps you perform data calculation and analysis in AirSheet / Worksheet. It provides the tools you need to enter and evaluate REPLACE formulas efficiently, making your work more efficient and helping you accomplish tasks with ease. With REPLACE, you can type a formula starting with =, enter REPLACE( to view syntax guidance with parameter requirements and examples, supply the required arguments, and confirm the formula to display results in a cell. It also supports flexible parameters, cross-worksheet references, nested calculations, and automatic recalculation when source data changes. Whether you're correcting formula syntax, checking parameter types and counts, reviewing references, or manually triggering recalculation when results seem incorrect, REPLACE helps you stay productive and complete tasks efficiently across different work environments. Choose the documentation below that best matches your needs to learn more.

1:53