I was hoping someone would be able to assist me with a question I have regarding a text-to-columns type scenario. I have copied names, number, address and titles from a website but when i past it into excel it all goes into column A. Normally, if the data was uniform and consistent, you could easily use text to columns.
The data i have is separated with various delimiters and is of varying lengths. Some of the cells contain all of the fields (name, address, number, title), while other may only have 2 of the field criteria (i.e. name and number).
I have tried to replace all the delimiters with a "," so i could attempt to separate it by text-to-columns. However, since the information in each field is not the same length I end up with a cell phone number in the "address" column or a address in the "position" column. There is too much data to manually clean this up after performing the text-to-columns
Does anyone happen to have a solution for parsing out this type of information? Any information would be helpful! Thank you!
<tbody>
</tbody>
The data i have is separated with various delimiters and is of varying lengths. Some of the cells contain all of the fields (name, address, number, title), while other may only have 2 of the field criteria (i.e. name and number).
I have tried to replace all the delimiters with a "," so i could attempt to separate it by text-to-columns. However, since the information in each field is not the same length I end up with a cell phone number in the "address" column or a address in the "position" column. There is too much data to manually clean this up after performing the text-to-columns
Does anyone happen to have a solution for parsing out this type of information? Any information would be helpful! Thank you!
COLUMN A | NAME | POSITION | PHONE | ||
1 | Jack Drisko, Contracting Officer, Email dracccc@state.gov - Donald Johnson, Subject Matter Expert, Email Johnson@state.gov | ||||
2 | Larry Bird, Senior Contracting Officer, Phone 7038009999, Email BigLA@state.gov - Excel Help Team, Mailbox, Excel_Help_Team@state.gov | ||||
3 | Steph Curry, Phone 7038009999, Email stephcurry@state.gov - James Johnson, Contracting Officer, Phone 7038000999, Email Jonsonjix@state.gov | ||||
4 | Don McNabb, Email Mcnabb@state.gov | ||||
5 | Jack Ryan, Phone 7030998898 Email JackRRyan@state.gov - John M. Piecrce Contracting Officer , Phone 703-999-8897, Email Okaygoogle@state.gov | ||||
<tbody>
</tbody>
Last edited: