Left with Find vba

I am unable to get the find function working in excel. Basically what I am trying to do is return the left portion of a cell until the string "/" is found.

Please Login or Register  to view this content.

I have attached a trial spreadsheet.

The solution in your second post works but why does it require double quotes to work. Single quotes work with find in excel formula.
I would never have figured that one out.

I have tried unsuccessfully to get instr to work with left. Can you please show me what the syntax would be to make that work.

Originally Posted by Richard Buttrey

Hi,

Range("C2").Value = Left(Instr(A2),"/")

Re your 1st Q. The Excel formula Alan has given you, when entered directly in Excel itself contains a string literal, viz "/". When entered using VBA the whole formula is already encloses in its own "" literal quotes, hence any embedded quotes that are integral to an Exccel formula need to be further wrapped in their own quotes. Hence that's why you often see the ""sometext"" construction in VBA code that is adding a formula to the worksheet.

Excellent. Thank you