0

In LibreOfficeCalc i have a single column with 2 values like this

enter image description here

I have to split this into 2 as given below:

enter image description here

How can i do this??

Wai Ha Lee
  • 8,598
  • 83
  • 57
  • 92
Gadheyan .t.s
  • 377
  • 2
  • 9
  • 23

1 Answers1

1
  • Highlight the column / section of data you want to split;
  • Select Data > Text to columns from the menu;
  • From the Text to columns dialog, specify Separated by Other, and enter / as the separator;
  • Click OK.