0

Related topic: Auto serial number and text in google sheet: "Number - Text" by dragging

Formula from player0:

=TEXT(ROW(A1), "00")&" - ABC"

This formula gets a number of rows, like in column C in the attached image.

I want to the get "number of cell" in column A", like in column B.

How can I calculate it?

Please see the image.

Enter image description here

Peter Mortensen
  • 30,738
  • 21
  • 105
  • 131

1 Answers1

1

Try

=TEXT(ROW(), "00")&" - ABC"

and see if that helps?

JPV
  • 26,499
  • 4
  • 33
  • 48
  • As a reference, see [ROW function (Google Editors Help)](https://support.google.com/docs/answer/3093316?hl=en) for more information. – Martí Jun 18 '21 at 11:25