Hi
I have a large spreadsheet that as one column with all the information. I want to spilt the data into different columns before and after a ; appears (example line below). I have looked for Trim commands on google but cannot find anything quite what I am after. Could some assist please. Thanks in advance
26413;RB/8277240792;FSC Mix Credit;RW BC;30x148;5400;223;5.347
I have a large spreadsheet that as one column with all the information. I want to spilt the data into different columns before and after a ; appears (example line below). I have looked for Trim commands on google but cannot find anything quite what I am after. Could some assist please. Thanks in advance
26413;RB/8277240792;FSC Mix Credit;RW BC;30x148;5400;223;5.347