LinkBack URL
About LinkBacks
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))
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))
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks