I am currently using Excel on Windows 2010. I have two rows of data I need cell one to be updated to the information in cell two based on a 6 character number in cell one.
Example of my issue:
Cell one has FEB109
Cell two has mobile-1842-FEB109 or 1234-FEB109-w67 or WU26-123-FEB109.
How would I merge the two together so that I can get cell one to represent the data in cell two?
Any help would be much appreciated.
Bookmarks