Hi I have a Excel sheet currently organized in two columns. The first is a location number and the Second a record of what is there as a from to number separated by -.
I want to change this second column into 3 separate columns first column first number second column a - third column last number. See Example below.
DAN1201 31759 - 31838
DAN1202 31839 - 31856
into
DAN1201 31759 - 31838
DAN1202 31839 - 31856
Many thanks
Darryl
Bookmarks