Pasting Dates Using GoTo Adds Dates In Deselected Cells

[flagmoa]

Hi!

I'm copying dates to separate them from middle initials that are in the same row. I used GoTo to select only dates, but when I paste them they all seem to change after the first blank.

I'm trying to move them 1 row over to the empty cells as you can see in the picture provided. How can I go about this?

Thank you in advance!

 

[GlennUK]

Paste them where? What exactly happens when you paste? What are you expecting to happen when you paste? What do you mean by "1 row over" - do you actually mean "1 column over"?