Hi All,
I have a few data in column A which is contains title and company. Here I need to separate the title and company. There is special character "," between title and company. But in few cases it is having more delimiter. Please find the attachment.
I'd use text-to-columns with a delimiter of comma. You'd have to do some manual processing if you're wanting to not have more than two columns but it seems like the easiest way.
I have huge set of data to be done.
For the part, use this in E2 copied down...
=LEFT(A2,FIND("xx",SUBSTITUTE(A2,",","xx",LEN(A2)-LEN(SUBSTITUTE(A2,",",""))))-1)
Then in F2, copied down...
=MID(A2,LEN(E2)+3,99)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank You I Had Got The Result
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks