Extract String

[DaveS002]

I have a string of the for nn:nnn and I want to extract the digits represented by n's. The number to the right of the colon is always 3 digits. The number to the left of the colon is either 1,2, or 3 digits. How can I extract these two numbers.

[martindwilson]

is this a time? well probably not since there are 3 to right so

=LEFT(A1,FIND(":",A1)-1) and
=right(a1,3)

[contaminated]

Hi and welcome to the forum

For the left two numbers: =LEFT(A1,SEARCH(":",A1)-1)
For th right 3 numbers =RIGHT(A1,LEN(A1)-SEARCH(":",A1))