Thread: Macro to find a comma in a string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck[_11_] Chuck[_11_] is offline
external usenet poster
  
Posts: 58
Default Macro to find a comma in a string
A1 contains LastName, FirstName
If B1 = mid(A1,1,find(",",A1)-1) then B1 will be = to the LastName.
How can I write a macro that will returen the LastName to whatever the
ActiveCell is?

Chuck L
Reply With QuoteReply With Quote