Hi

With your data in A1 the formulas below will retrieve data Left / Right to
the "-"

=LEFT(A1;FIND("-";A1)-1)
=RIGHT(A1;FIND("-";A1)+1)

Regards,
Per

"Ken" skrev i meddelelsen
...
I have a column with various data in it
How do I delete all the data to the left or right of a certain criteria in
this case a €œ-€œ. The data is not aligned so text to columns doesnt work