Excel 2010: I had one cell that contained a Name and phone number. The cell was also hyperlinked to a webpage. I used the =left and =right functions to separate the two sets of data into two separate cells. However, now the Name cell doesn't have a hyperlink. Is there anyway that I can copy/paste the hyperlink from the original cell over to the new cell? Or, an alternative, can I remove the data in the original cell, but not the hyperlink and then copy/paste the Name over to the hyperlinked cell? Also, this needs to be done in bulk because I have 1000+ of these to go through. Any feedback on this would be greatly appreciated. Thanks in advance!