I currently have a workbook containing various data from which I am extracting only the information I need. Most columns are fine but new columns F & G are trying to extract data from columns L & M and this is where I need help. I want to end up with ONLY column G which should be the mobile telephone numbers of the candidate. I do not want the words "Mobile: ", nor do I want the unnecessary "+44" or "-" or "044" etc. If there is no mobile number entered in column M I then want to pick up the number contained in column L, again without the same unnecessary "Phone" or"+44" or "-" or "044" etc. I also want the end resulting column to be formatted as text rather than a number, with a leading 0 in front of the final tel no. ie 07788665544.
Thank you very much for any help - I am, as is fairly obvious, a novice as functions, nesting, etc
Bookmarks