Thanks M60
I'll take you up on that, never know what you might pick up. I tried putting various numbers into the career placings box and it worked every time??
I'm at gittarstuff at aanet dot com dot au
Best regards

Hi Surround...

been struggling again and using your last great help.....but been trying to get rid of that Distance word so l can use your formula of taking 12-4-2-5

in different colm....and everything going good have a few probelms to sort out .... Thanks again

Attached Files

Last Help welllll .xlsx (9.5 KB, 483 views)

Hi M60

Try this.

Attached Files

Copy of Last Help welllll .xlsx.xlsx (9.8 KB, 430 views)

Hi Surround....been up trying your last reply before seeing l made a stuffup...sorry to be a pain ...again Thanks ...

Attached Files

toSurroundreply .xlsx (10.1 KB, 444 views)

Hi M60

That last formula just takes out the characters before the data you want.
Where it says "-8" it takes out 8 characters.
Change "-8" to "- 9" or "-10" and it will remove that number of characters.
Best way to learn excel.
Give it a go.
Any probs - yell out.

It's not a formula, it's a macro. Simple Record Macro, a few tweaks here and there, noooo rocket science.

Thank you to Surround, learn this stuff to some day

Attached Files

splitter.xls (40.0 KB, 423 views)

Hi Surround again thanks for your great imput...after a few hours finally got them working ...but if you take have 16:12-4-1 and use 6:2-2-1...lt goes weird... yeah hear ya "like me" ...have Attach may help someone with what you have shown...yeah l know learning excel would have help heaps but got a few grey hairs left and under them not that much good..just for the couple thingsl'll have no more need for excel...but Thank you for your help....M60

Attached Files

DistStstFormulas .xlsx (12.8 KB, 439 views)

M60
How about you send me your spreadsheet.
It seems to change all the time.
You have my email address.
I hope I can help.

Hi Surround ....l'm at pres..redoing....hopefull tonight be fin...M60

Hi M60
This is what you've given as the different formats of your data.
Which of these (if any) is the format your data will be in when you bring it into your spreadsheet.

Distance 12-10-2-5

Distance: 12:10-2-5

16:19-12-2

Those are what you have shown on your last spreadsheet.
We can probably help if we know what it is and it doesn't keep changing.