I need to split the cell contents based on a rule.
## Deliverables
I need to split a column of data in to two new columns.
? I want this "XM95-7/32x6x8 to become "XM95" & "7/32 x 6 x 8"
other data in the column may look like?
"MSD-Hex-1" I want it to be "MSD" ? & "Hex-1"
the rules, look from left to right and split and remove at the dash. Add spaces between "X"'s ? on the new right column.
If there is no dash, leave as is.
I want you to provide me with the formula