Tag Info

Hot answers tagged


In Column B next to A: =left($A2,FIND(",", $A2,1)-1) In Column C next to B: =mid($A2,FIND(",", $A2,1)+2,len($A2)-len($B2)) will give you answers: After entering the formulas, you pull the fill-in handle and drag the columns B and C down, until last line of data. Also if you want the data to be the real text part of the string in A1 then you have to ...

Only top voted, non community-wiki answers of a minimum length are eligible