View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Glen[_5_] Glen[_5_] is offline
external usenet poster
 
Posts: 31
Default 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)