Hi Good Evening from Sri Lanka,

Guys I have a massive challenge here, I normally wouldn't post URGENT, If it isn't.

Please help if possible.

I am only looking for a UDFs or Formulas. Not interested in Macro as lots of sensitive data and numbers are present and I don't want to be in a mess. UDFs or a formulaS would easily help me Target what I need here.

Data I have :-

Cell A1 = Phone: 81-74568943 Fax: -
Cell A2 = Phone: 51-83-9498756, 5583772359 Fax: 61-88-4932516
Cell A3 = Phone: 51-6785239556, Fax: 31-13-45225335
Cell A4 = Phone: 51-6785239556, Fax: 31-13-45225335, Mobile: -

What I need :-

B1 = Phone (As a data which we have pulled out from A1)
C1 = 81-74568943
D1 = Fax
E1 = - (Or N/A - Not the N/A Error Message or a value! error message, But just the letters : N/A)
F1 = Mobile
G1 = - (Or N/A - Not the N/A Error Message or a value! error message, But just the letters : N/A)

Similarly, I need to get the same outcome for the A2:A4,

I wouldn't mind 2 contact Numbers in the same cell with a coma separating it. ex : Situation in A2

Please Help Me. Thank You so Much Every Lady and Gentleman out there !