filling a series

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I fill a series of cells with dragging, where the first entry is
"PV-A", and the filled cells are "PV-B", "PV-C", and so on?
 
Hi
try the following in A1:
="PV-" & CHAR(64+ROW())
and copy down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to hide a formula and display something else? 4
Counting 4
Solving two equations with known exponent 5
Data Entry Form: Macro-One To Many 10
Series fill only copying and fill series greyed out 1
Solving for Amortization with PMT function 3
Which XL formula calculates Present Value of a single lump-sum Payment in 2027? 2
Logical 1

Back
Top