Autofill 1A 2A 3A and So On

[uckycool]

Hello guys!

How to make autofill in a series of 1A 2A 3A and so on in one column?
Since if we drag down "1A 2A 3A" it will copy the same content as the above and not make a fill in a series?

Thank you before!

[humdingaling]

use formula

Please Login or Register  to view this content.

then copy and paste values once you are done

[protonLeah]

One way, in A1:
=Row() & "A"

[uckycool]

Thank you guys!
However my figures are more complex than that. I have to fill FEM15S-852B, FEM15S-853B, FEM15S-854B and so on in a series and it is not related to the row they are located.
I again attach a sheet with the updated figures.
Thanks!

[humdingaling]

try this then

Please Login or Register  to view this content.

[uckycool]

try this then

Please Login or Register  to view this content.

big thanks humdingaling.

however, do you have a formula that not related to the row of the content?
since by using that formula, I can't copy paste it directly to other cells with different row position.
example: if I want to move "FEM15S-852B" which originally in the row 1 to row 2 by using ="FEM15S-"&851+ROW()&"B", then I have to change the formula to ="FEM15S-"&850+ROW()&"B" first.

I intend to share the sheet containing this formula with my partners. I hope for a formula that could be shared easily. :D thanks!

[sktneer]

If your string in A1 always follow the same pattern i.e. few letters followed by a hyphen followed by a number followed by a single letter, I would do it like this instead of hard coding the string in the formula.....
Assuming A1 contains FEM15S-852B, then

In A2

Please Login or Register  to view this content.

and copy down.

This way you can place any string in A1 with the same pattern.

[humdingaling]

with any formula solution.....if you don't copy & paste values after doing it....the formula may or may not have the correct context as it needs to be in reference to something

[FDibbins]

big thanks humdingaling.
however, do you have a formula that not related to the row of the content?

The ROW function is not really linked to any cell content, its is ONLY being used as a counter - it is not even looking at any cell.

To demonstrate this, put =ROW() in A1...it will show 1
copy it down, and it will show 2, 3, 4 etc.

Because your numbering starts at 851, humding is taking that value, and adding it to the row(). Perhaps a slightly different approach would have been to use =ROW(A1), but this can break down if you insert rows

[uckycool]

Thanks guys for helping me a lot. But I would use the sktneer formula since I got it just what I want.
Huge thanks guys! :D

[FDibbins]

Happy to help, thanks for the feedback