Text to coulmn - Date issue

  • Hi


    I got 4500 rows with different kind of descriptions.
    For example. "Signal Border 1-3 (DCA-WTA-Q)"


    I want to divide these in to diffrent columns.
    I used the function "from text to column", but instead of "1-3" it showed "01-mar".
    This happend to a lot of the numbers, but not all.


    Is there a way to avoid this happening?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!