Using the Find function to get Left or Right data
Can anyone help me figure out what I have wrong here. I think the code
shows what I am trying to do. The problem with simply using a Left()
or Right() function is the data size changes, of course and I am
splitting the data. I know this will work, but I can't get it to. I
keep getting the error: Sub or function not defined for Find.
strDWG = Range("J" & i & "").Value
'dwgNSN = Left(strDWG, 18)
dwgNSN = Left(strDWG, Find("/", strDWG) - 1)
'dwgMFR = Right(strDWG, 18)
dwgMFR = Right(strDWG, Find("/", strDWG) + 1)
|