Excel2007 advanced copying into blank row

Closed
alyssadesirae - Oct 29, 2010 at 06:17 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 29, 2010 at 07:07 PM
Hello, I used a macro to insert blank rows into my spreadsheet. Now I need to copy the exact same numbers into the blank rows and add the letter A to them. I only need this for 1 column not all columns.
ie.
5000
5000A (blank)
5001
5001A (blank)

I need an easier way to do this than click and ctrl drag, then inserting an A!

Thanks for your help!



1 reply

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
Oct 29, 2010 at 07:07 PM
insert a blank column and use this formula:
=CONCATENATE(A1,"A")

Then copy and paste special values over the top of itself. You can then delete the original column
0