# Autofill 1A 2A 3A and So On

1. ## Autofill 1A 2A 3A and So On

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!

2. ## Re: Autofill 1A 2A 3A and So On

use formula
Formula:
`Please Login or Register  to view this content.`

then copy and paste values once you are done

3. ## Re: Autofill 1A 2A 3A and So On

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

4. ## Re: Autofill 1A 2A 3A and So On

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!

5. ## Re: Autofill 1A 2A 3A and So On

try this then
Formula:
`Please Login or Register  to view this content.`

6. ## Re: Autofill 1A 2A 3A and So On

Originally Posted by humdingaling
try this then
Formula:
`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!

7. ## Re: Autofill 1A 2A 3A and So On

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.

8. ## Re: Autofill 1A 2A 3A and So On

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

9. ## Re: Autofill 1A 2A 3A and So On

Originally Posted by uckycool
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

10. ## Re: Autofill 1A 2A 3A and So On

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

11. ## Re: Autofill 1A 2A 3A and So On

Happy to help, thanks for the feedback

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1