Cell with values separated by commas

[Jason Fenwick]

I have a cell with these values in it can anyone shed any light on extracting the single values between the commas into their own individual cells. Thanks in advance guys.

2,5000,8,Y

 

[Jonmo1]

Welcome to the board.

Try Data - Text To Columns
Delminated - Next
Comma - Next
In the Destination box, Select the cell to the right of the original cell and click Finish.

 

[Jason Fenwick]

Thanks Jonmo1;4319746 that's exactly what I was looking for. I couldn't find it for looking.

 

[Jonmo1]

You're welcome.