ExcelBanter - filling a series

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - filling a series (https://www.excelbanter.com/excel-discussion-misc-queries/1864-filling-series.html)

Wazooli

filling a series

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?

Frank Kabel

Hi
try the following in A1:
="PV-" & CHAR(64+ROW())
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

Wazooli wrote:
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?

All times are GMT +1. The time now is 08:22 PM.