hi, i have a string in A1 as
i want the output in B1 asHTML Code:
108031052,108043871
What functionality do i need to use??
Thanks,
hi, i have a string in A1 as
i want the output in B1 asHTML Code:
108031052,108043871
What functionality do i need to use??
Thanks,
Can you post a few more examples, so we can see what kind of variations you have to deal with?
Pete
Assuming all your data is in the same format, try this...
=MID(A1,FIND("(",A1,1)-10,9)&","&MID(A1,FIND("(",A1,FIND("(",A1,1)+1)-10,9)
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
Hi FDibbins,
Thank u so much for your help.
Sometime i have more than 2 strings seperated by a comma. Can we change the formula to split into depending on the string separated by commas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks