How about this Regex
![]()
Function jec(cell As String) As String With CreateObject("vbscript.regexp") .Global = True .ignorecase = True .Pattern = "(T|\s)(\d\d+)(\.\d+\.\d|\.\d+)?" jec = LTrim(.Execute(cell)(0)) End With End Function
How about this Regex
![]()
Function jec(cell As String) As String With CreateObject("vbscript.regexp") .Global = True .ignorecase = True .Pattern = "(T|\s)(\d\d+)(\.\d+\.\d|\.\d+)?" jec = LTrim(.Execute(cell)(0)) End With End Function
Last edited by JEC.; 11-16-2021 at 04:55 PM.
I have not tried it ,will it convert the sheet macro enabled excel file ? a function i have to use with that file ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks