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

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"excel idiot" wrote in message
...
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

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

"Ken Wright" wrote:

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"excel idiot" wrote in message
...
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

You're very welcome, and thanks for the feedback :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"excel idiot" wrote in message
...
Thank you so much! You just saved me hours of work.

"Ken Wright" wrote:

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"excel idiot" wrote in message
...
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