For some reason I am thinking this is prob an easy fix but I can't think of how!!

My hubby manually entered comments on a project noting steps he took to solve the issue INSTEAD of entering the information into a new column (he's kinda new to Excel)..well now he needs to print it and his boss wants it all in a new column.

Is there anyway to copy comment text into a new column without manually opening each comment and pasting it into the next column????

Thanks