• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract specific data within column

udprocks

Member
Please remember to follow all forum rules: Cross-posting
Dear sir's,

I need help (if possible), with a column that has data messed up.

Please see attached file, a sample with the result.

Many thanks in advance.

Best,
Jitendra
 

Attachments

Last edited:

udprocks

Member
Hi,

A formula and PQ (if available for you) solution attached.
Sir,

If possible, another request could you please see below


Alex HorneDRE #: 02037293949.270.0440alex.horne@elliman.com


data is in a column like this need above,

I need to seprate like same in previous

Name Phone email
Alex Horne 949.270.0440 alex.horne@elliman.com


Note*after DRE#: there is 8 digits which is not phone number actually its another sequence in every cell, after 8 digit phone number starting


please help me out here if you can, otherwise I have to do it manully, please let me know.

Thanks and best regards
 

udprocks

Member

need response not these please.
 
Top