Hello,

Some Chemistry Outputs (such as the chem tables) only output the sample depth as either a depth range, or an average, rather than both individual "From" and  "To" values - which is more designed for reporting.

To split a range into a from and to, using a hyphen as a delimiter you can use the standard "text to columns" tool in Excel, typically found in the "Data" tab.

If this is an intermdiary step for further analysis (it sounds like it might be) then it is possible that we could recommend a more efficient approach to getting the data how you want, but we would need specifics. 

Warwick