Copy data from one cell to another

E

excel idiot

I have a list of data that looks like this:

A B
1 123-45-6789 5.82
2
3 ---------------- -----
4 234-56-7890 9.53
5
6 ---------------- ------

I need it to look like this:

A B
1 123-45-6789 5.82
2 123-45-6789
3 ---------------- -----
4 234-56-7890 9.53
5 234-56-7890
6 ---------------- ------

I have never done a macro before, so a function would be great if possible.

Thank you in advance for any help!
Dawn
 
K

Ken Wright

Select all of column A, do Edit / Go To / Special / Blanks, Type = but
don't hit enter, hit the UP arrow once and then hit CTRL+ENTER together.
Now select Col A again and then copy and paste special as values.
 
Top