Autofill in Ms. Excel

[sky103]

We can use autofill for data like, "name1" and it can autofill for another cell "name2"..."name3"..."name100".

But how to use autofill for data in cell like this : (name1) so autofill do "(name2)"..."(name3)"...""name100)".

Can i do that ? How ? Please tell me if there a way to do that.

 

[GigaGreg]

I have never used stuff like that before, I have done so many years on excel, but this is something new to me what you want to know.

 

[Peter]

In LibreOffice you can give the cell the following value:

=CONCATENATE("(name",ROW(),")")

This will give the result "(name1)" if the row number is 1, "(name33)" if the row number is 33, etc. If the numbers does not line up with the row numbers you'll have to subtract or add to the ROW() value. You can probably do something similar in Excel.

 

[sky103]

I have never used stuff like that before, I have done so many years on excel, but this is something new to me what you want to know.

I need to trick something, so i need it

In LibreOffice you can give the cell the following value:

=CONCATENATE("(name",ROW(),")")

This will give the result "(name1)" if the row number is 1, "(name33)" if the row number is 33, etc. If the numbers does not line up with the row numbers you'll have to subtract or add to the ROW() value. You can probably do something similar in Excel.

Ok, it's great. Thanks .
I will download LibreOffice and try it.

 

[GigaGreg]

Oh right, I think that you could search through youtube, there is everything.