LinkBack URL
About LinkBacks
=left(a1,5)
=left(a1,5)
Gary's Student
the "sales" can be anywhere in the text string. it could be in the middle, first, or last...
O.K. then.
If A1 contains the full string and B1 contains "Sales"
then the formula:
=FIND(B1,A1) will tell you where in A1, B1 can be found. For example if A1 contains:
hfshfjssalesvcjvh
the formula will return 8
Is this what you need???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks