Duplicate a cell

[anonyy]

hi

i have some rows i need to fill in that will have the same text except the end must have a letter that is different to the last a, b, c etc how do i do this? i did try the right click/drag but it just copies whatever is there in the selection, i did solve this for myself about a month ago but I forgot what to do?

Help

[Special-K]

What do you want the output to say, specifically?

[anonyy]

the cells should be the same to each other but with just a different letter of alphabet at the end i.e

John Doe Does Not Exist A
John Doe Does Not Exist B
John Doe Does Not Exist C

or i could use numbers, doesn't really matter as long as the end character is different

there is over 150 of them so dont want to do this manually.

hope you understand

[Special-K]

Try

"John Does Not Exist "&CHAR(64+ROWS($1:1))
and copy down

[anonyy]

sorry but i dont understand what this is doing i just just copies the wh9ole formula into the cells its not added the extra letter or number? I havent worked with excel properly for years so forgot how to apply formulas etc

[anonyy]

can anyone help with this?