Share via

Complicated Messy Data Sets Power Query and Split Columns won't work

Anonymous
2024-08-27T20:49:30+00:00

Hello,

I'm dealing with several data items within the same cells in different formats.

None of the clean options seem to work. When I try to find and replace, I have it entered as ( and then replace with (leave blank). Maybe there's a way to use wildcards to fix this? Please help!

For example:

Ph. 999-999-9999

C: 999-999-9999

C: 999.999.9999

Joe: 999-999-9999

999-999-9999 Joe C: 999-999-9999

Office (999) 999-9999D: (999) 999-9999C: (999)999-9999

Paula: 999-999-9999JD: 999-999-9999/Cell:999-999-9999Tom: 999-999-9999/D:999-999-9999

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-08-29T23:32:57+00:00

    One does not understand the expected solution by just reading a paragraph. Clearly show the expected result. It's OK if you do not want to - just that i will not be able to help you at all.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-08-29T20:35:13+00:00

    What do you mean by what results I'm looking for? I thought I described my question clearly. Please let me know if this is helpful? I need this data to be separated.

    I need the phone numbers and names to be in a workable format to import into Outlook contacts. All of the junk formatting within a single cell is messing it up and won't export to a CSV file correctly. Even Power Query/Delimiting isn't working to clean it up.

    Was this answer helpful?

    0 comments No comments
  3. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-08-27T23:49:31+00:00

    Hi,

    Clearly show the result you are looking for.

    Was this answer helpful?

    0 comments No comments