Find and replace across files in Figma - Cell-by-Cell Formula Trace

Sample Data

This data represents report titles and descriptions across multiple files in a BI project.

Cell	Value
A1	Title
B1	Description
A2	Sales Report
B2	Monthly sales data
A3	Sales Summary
B3	Summary of sales
A4	Sales Report 2023
B4	Annual sales data
A5	Marketing Report
B5	Marketing campaign data

Formula Trace

Find and replace 'Sales' with 'Revenue' across all titles (A2:A5)

Step 1: Check cell A2 value 'Sales Report' for 'Sales'

Step 2: Replace 'Sales' with 'Revenue' in A2

Step 3: Check cell A3 value 'Sales Summary' for 'Sales'

Step 4: Replace 'Sales' with 'Revenue' in A3

Step 5: Check cell A4 value 'Sales Report 2023' for 'Sales'

Step 6: Replace 'Sales' with 'Revenue' in A4

Step 7: Check cell A5 value 'Marketing Report' for 'Sales'

Cell Reference Map

    A                 B
1 | Title            | Description           |
2 | Sales Report     | Monthly sales data    |
3 | Sales Summary    | Summary of sales      |
4 | Sales Report 2023| Annual sales data     |
5 | Marketing Report | Marketing campaign data|

Arrows point from A2:A5 to the find and replace operation.

The formula references cells A2 to A5 where the find and replace operation is applied.

Result

    A                   B
1 | Title              | Description           |
2 | Revenue Report     | Monthly sales data    |
3 | Revenue Summary    | Summary of sales      |
4 | Revenue Report 2023| Annual sales data     |
5 | Marketing Report   | Marketing campaign data|

The final result shows all occurrences of 'Sales' replaced with 'Revenue' in the titles from A2 to A4. A5 remains unchanged.

Sheet Trace Quiz - 3 Questions

Which cells had 'Sales' replaced with 'Revenue'?

A A2, A3, A4

B A2, A5

C A3, A5

D A4, A5

Key Result

Find and replace scans each cell in the range and substitutes matching text with new text.