This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
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.
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.
Hi,
Clearly show the result you are looking for.