hello -
can you use the Mid function to seek out a string that starts with a certain letter up to the first empty space?
Thanks,
hello -
can you use the Mid function to seek out a string that starts with a certain letter up to the first empty space?
Thanks,
The Mid function can't be used to search for anything.
If you want to search for a character/space in a string use InStr (VBA) or FIND/SEARCH (worksheet).
Once you've found the character/space then you can use Mid if you want to extract particular data.
If posting code please use code tags, see here.
Like this for instance
Formula:Please Login or Register to view this content.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
For mine I used:
Trying to get to the string that starts with 'P' and rteturn it up until the first empty space.Please Login or Register to view this content.
It isn't 100% clear what you want but perhaps this.
Please Login or Register to view this content.
This function will return the first word that being with the letter "p".
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks