I have an Excel, which has Database with two columns, Name & Tel. No.
The user gets his details of telephone which only has no.'s
He wants to copy the no.'s & excel should look into the first part & put the names in front.
I have attached a Sample Excel.
If possible Iwould like this to be achieved by formula & not VB, but if not please feel free to add Macro.