Copy data from one cell to another

[Guest]

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

 

[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.

 

[Guest]

Thank you so much! You just saved me hours of work.

 

[Ken Wright]

You're very welcome, and thanks for the feedback