and it has worked and put the customer name into a separate cell but i am still having difficulty putting the number into a separate cell. I presume it is a variation of the code to extract the name but i seem unable to create the variation that works. Please could you advise on that as well.
However i have just discovered that if the number starts with a 0 I need to remove the 0 at the beginning as well in order for the following formula to work.
This formula re-instates the complete number which was the original reference.
Any thoughts?
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!