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.
