Help with Splitting Columns

Question

Hi There,&nbsp;I used this code to split L52, L12 , L13, L4, but I couldn't get LW to also split.&nbsp;&nbsp;Any idea on what to type to make sure LW is kept in attribute 1 column while the other letters are moved to attribute 2 column?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks!&nbsp;&nbsp;

padycosmos · Answer

Hope this helps:&nbsp;&nbsp;&nbsp;&nbsp;

ukfan12 · Answer

Sorry it is probably something I did wrong but this did not work. I changed my message up to hopefully be a little more clear. Thanks for the help!

padycosmos · Answer

Hope this helps:https://blog.crossjoin.co.uk/2019/02/12/splitting-text-by-character-transition-power-bi-power-query-excel/

Forum Discussion

Help with Splitting Columns

3 Replies

Related content

Splitting Column values

Split a column into two separate columns

Split Columns

Column Splitting

Split and rearrange columns