I'm sorry if I'm just thick, but I can't find any function to automatically insert text from one cell into another. I don't want to do anything to the text, just automatically copy the text in one cell into another. This seems as if it would be so simple, but I can't work out how to do it. I have made sure that both cells - the target and the original are formatted as text, and I have looked through all the text related functions listed under "Insert > Function", but I haven't had any luck. I am using Excel 2003 & Windows XP Home SP2.
Bookmarks