Hi, I am trying to find away to split up data that is entered as text into a cell,and split that text data into 3 columns. Sample text enters in a cell can be:
10-3 or 1-3-1 or 12-11-0 or 1-6 or 8-8. As you can see, the text entry can have two or three numbers in it. I would like to split this data so it looks like this: 10-3 would be cell A5=10, cell A6=3 and cell A7 is blank. Another example would be 1-3-1 would be split A5=1, A6=3 and A7=1.

I hope I explained this well enough. Thanks for your help on this matter. Oh, I know about the text to column function, but that will not help me in this case as I want the data to split automatically with a formula.

Once again, thanks for your help.
Ted