To concatenate a calculated number from cells in column A and a note title from column B into cells in Column C Note Number and Title

1. Type the following formula into cell C2: ="Note "&" "& A2 &" - "& B2

This formula concatenates the text Note with the number returned from the formula in cell A2 and the text in cell B2. For example, the returned result for the first Note is: Note 1 — Summary of Significant Accounting Policies

2. Copy the formula to the cells in column C. When deleting or adding a Note, all Notes will be updated with the new calculation numbers returned from the formulas in column A.

0 0

Post a comment