Suggestions for Normalizing Mobile Numbers in Excel

Hello, any suggestions for normalizing mobile numbers in the column? Even when I export to Excel and use Formant Cells>Special>Phone Numbers, it's still not right. Thanks!

✅1

15 comments

Doug Y.
·
·
https://app.clay.com/workspaces/28019/tables/t_fGgGUEdIHNup/views/gv_gPcMvqa2T33E
Clay Team
APP
·
·
Hey there Doug sorry for the delay. I the "Enrich Data" menu if you search for "normalize numbers" there is an integration that you can use. In the add fields selection you can choose what format you want to normalize into.
:sparkles-clay:1
Doug Y.
·
·
Thank you!
Doug Y.
·
·
I did get this error tho:
Clay Team
APP
·
·
The column limit for a table is 70, you will need to remove a couple columns to be able to run this integration. If there are certain integration you are confidant you do not need to run again than you can remove the integration.
Doug Y.
·
·
Cool, got it, thank you. Weird though, since there are only 49 columns, right?
Clay Team
APP
·
·
Yes, I'll make a ticket and send this to the engineering team
Doug Y.
·
·
thank you!
Doug Y.
·
·
Hi LuisArturo, curious if the issue's been resolved?
Clay Team
APP
·
·
Hi there Doug, have not heard anything yet. Bit of a backlog, but I'll send a ping.
:sparkles-clay:1
Doug Y.
·
·
Good morning, LuisArturo, wanted to circle back on this. Do you know if the issue was resolved? Thanks!
Clay Team
APP
·
·
Hey Doug, jumping in here for Luis in the meantime. I think this is another limit we have actually.Out of the total of 70 columns, you can only add up to 30 integrations or enrichments by default. This is to prevent any performance issues.
Clay Team
APP
·
·
Are there any integrations that you may not need in the table, else, I'll check if we can add one more for you.
Clay Team
APP
·
·
I see, you pretty much have only waterfalls here. Let me try increasing this for you so it can be added.Could you try adding the column now?
Doug Y.
·
·
Arturo O. looks good now! thanks!