Need Help Separating Data in a Cell

Copper Contributor

i, I am hoping someone can assist me.  I have a file with addresses that need to be separated by street number, street name, suite number, city, state & zip.  Currently this information is all in one cell and does not have commas or set spaces.  How can I separate this easily?  I have 50,000 records.   

1 Reply

@LauraPlate 

You can apply a delimiter, however, this can vary based on how your data is structured. Can you share a sample data pool or screenshot of how the data looks?