If you've tried to split or separate text string that's delimited by commas ( or semicolons) it's a straight forward process using the text to columns feature. However if you have some values that are enclosed in parenthesis or brackets and you don't want that text to be separated, it wouldn't work. There is a workaround that this video goes through. One is a VBA solutions provided from iliace at the mrexcel forum (https://www.mrexcel.com/board/threads/separating-commas-and-parenthesis.403833/) and the other is an adjustment to the text with find/replace before using the text to column feature.
No comments:
Post a Comment