Adding the Same Characters to Multiple Cells

Question

I typed ", AL" after the end of the name of the city in cell A1. of the "Alabama" page of the attached spreadsheet.  Is it possible for me to highlight cells A1 thru J69, and, enter ", AL" to each of the cells with one entry?  Or, do I have to manually enter ", AL" to each cell?

https://1drv.ms/x/s!AqYCCLjWGsuVguQwBDbr404Pc7Vyqg

Answer 1

You can accomplish this through VBA only. I have created a VBA macro for you and you need to input the required characters. For example, if you input , AL Then ,AL will be appended in the selection.

1. Open the sheet where you want the Letters to be appended and select the required range
2. ALT+F8
3. Run the macro named "AppendLetters"
4. it will ask for the input
5. OK

(Note, if you want to use the Macro in future, you need to save your file with .xlsm extension)

Download the workbook from

https://1drv.ms/x/s!Akd5y6ruJhvhiVt-7H4ifO-9dSC0

Answer 2

type AL once to copy it Select the remaining cells, ie click and drag to paste the value into all of the selected cells.

Answer 3

Ciao,

sure you can!

1. Select cells A1 to J69
2. On the Home Tab, in the Numbers Group, please click on the arrow close to General
3. Choose other number formats
4. Select Custom
5. In the text box, delete Standard and type @"AL"
6. Click OK

Please let us know if this solves your issue!

Thanks Ugo