Re: find location
From: Leo Heuser (leo.heuser_at_NOSPAMadslhome.dk)
Date: 08/17/04
- Next message: Loane Sharp: "SELECT ... INTO ... IN ..."
- Previous message: Bigwheel: "Re: how to open a Workbook and activate a specific ***"
- In reply to: Ed: "find location"
- Next in thread: Don Guillett: "Re: find location"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Aug 2004 22:14:54 +0200
Ed
Check out the two functions
FIND() and SEARCH()
-- Best Regards Leo Heuser Followup to newsgroup only please. "Ed" <Ed@discussions.microsoft.com> skrev i en meddelelse news:1C7B4602-33BD-4389-B048-4A26A5F9FD69@microsoft.com... > sorry for this stupid question, > what is the command to put in the cell to find the location of a string.... > Column A > e.g. Mary, John =instr(A1, ",") i want the answer = 5 > Christine, Peter =instr(A2, ",") > = 10 > the above command work in Access/VB but not Excel.... > What is the command for Excel... > Thanks > Ed
- Next message: Loane Sharp: "SELECT ... INTO ... IN ..."
- Previous message: Bigwheel: "Re: how to open a Workbook and activate a specific ***"
- In reply to: Ed: "find location"
- Next in thread: Don Guillett: "Re: find location"
- Messages sorted by: [ date ] [ thread ]
