Separate Numbers

[Av8tordude]

I have a code that prints the 52 week range (i.e. 49.77 - 79.90). I would like to separate the numbers (49.77 & 79.90). I would be using each number in a label. Can someone assist.

Thanks

 

[alansidman]

If the 52 week range is located in one cell, then you can split the cell into 2 cells using the "-" as a delimiter.

On the ribbon on the Data Tab. Click on "Text to Columns" and follow the wizard instructions.