View Single Post
  #4   Report Post  
Old May 15th 19, 12:58 PM posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,673
Default Tricky regular expression

Hi,

Am Tue, 14 May 2019 03:30:24 -0700 (PDT) schrieb RG III:

Holy sheet! That works better than regular expression! 8)


another way:

sLine = "abc G. James #000"
str1 = Left(sLine, InStr(sLine, " ") - 1)
str2 = Trim(Replace(sLine, str1, ""))


Regards
Claus B.
--
Windows10
Office 2016