Forum Discussion

egspen2's avatar
egspen2
Copper Contributor
Sep 30, 2021

Custom number formatting - same text before changing numbers

What custom formatting option do I have to pick in order to have the same text appear before different numbers? For example, I'm trying to have cells in consecutive rows show:

 

Customer 1

Customer 2

Customer 3, so on and so forth but just want to be able to add "A1 + 1" and drag it down so that "Customer" automatically populates in front of each number.