Auto Bulk Rename

[Peeekay]

Hello there,

I was wondering if you guys could help me out.

I have a single entry in a cell and I would like a quick way to create 26 unique entries from it with each letter in the alphabet.

For example, lets say i have an entry in one of my cells called "resourcefinder.info" and I want to create 26 other unique entries that simply attach a letter of the alphabet to it allowing me to get something like this;

aresourcefinder.info
bresourcefinder.info
bresourcefinder.info
dresourcefinder.info
eresourcefinder.info
gresourcefinder.info
hresourcefinder.info
etc....


Check my sample sheet attached.

Thank for the help

[davegugg]

You can use the chr() function to add the letters. The lower case alphabet is numbers 97 - 122. I used basic arithmetic to get the answer in column B, cells 1 - 26.

Please Login or Register  to view this content.

[Maistrye]

If you don't want to use VBA, one way is to do it as follows:

Put the name in a cell (say A2):
A1: Name:
B1: resourcefinder.info

A3: 1
A4: 2
...
A28: 26

B3: =CHAR(CODE("a")+A3-1)&$B$1
[and drag down]

S

[Peeekay]

You can use the chr() function to add the letters. The lower case alphabet is numbers 97 - 122. I used basic arithmetic to get the answer in column B, cells 1 - 26.

Please Login or Register  to view this content.

The macro worked well except for the fact that I want the letters to append to the name, not to another cell.

Any ideas?

[Peeekay]

did some research and figured out that simply adding this formula to an adjacent cell does the trick = A1&B2

Thanks for the help everyone