maradykstra
New Member
Hello,
I want to separate text that is all one one cell. I'm familiar with the text to column with the delimiters and fixed width. The fixed width works very well, but not all text is lined up appropriately. An example of a text is:
Smith, Carol 3334 S. Camelot Way, SLC, UT 84012 (I want to separate the names from the addresses)
I have a list of similar text in one but different data. I can highlight the whole column and do the fixed width but spacing isn't distributed evenly so when I do the fixed width it'll cut some of the first names out. Also, when I do the delimiters, it's way too many cells afterwards so that's why the fixed width works but only one cell at a time.
Is there a faster way?
Thanks.
I want to separate text that is all one one cell. I'm familiar with the text to column with the delimiters and fixed width. The fixed width works very well, but not all text is lined up appropriately. An example of a text is:
Smith, Carol 3334 S. Camelot Way, SLC, UT 84012 (I want to separate the names from the addresses)
I have a list of similar text in one but different data. I can highlight the whole column and do the fixed width but spacing isn't distributed evenly so when I do the fixed width it'll cut some of the first names out. Also, when I do the delimiters, it's way too many cells afterwards so that's why the fixed width works but only one cell at a time.
Is there a faster way?
Thanks.