Forum Discussion
Text After Delimiter
Dear Experts, Could you please help in below Query:- In Attached Excel, I want my data like in Column "B" only the Text after 4 spaces(Item xx), then in Column "C" the text aft...
select *,replace(supportedBandCombinationList,' ', '</td><td>') a from split_one_cell_to_multiple;
peiyezhuSorry , I didn't get it.. Could you please apply the same in Excel sheet and attach the result.
Many Thanks!
Br,
Anupam
http://e.anyoupin.cn/EData/?s=supportedBandCombinationList
this online tool
attach is result of an excel book