How do I create a formula for Column B to add a prefix to the value in column A?

Occasional Visitor
1 Reply


Let's say the names begin in A3.

Enter the following formula in B3:




and fill down. If you want to be able to fill beyond the last used cell in column A, use