Hi,
I have attached an example. I would like to be able to create a function that only returns text up to a certain "space' in a text string.
Thanks in advance for taking a look at this.
Michael
Hi,
I have attached an example. I would like to be able to create a function that only returns text up to a certain "space' in a text string.
Thanks in advance for taking a look at this.
Michael
Last edited by mlopardo; 09-09-2011 at 06:07 PM.
As a start:
=MID(B7,1,FIND(" ",B7,FIND(" ",B7)+1))
You may need to be more sophisticated if there are "sentences" with one or less spaces in them.
In 2007:
=IFERROR(MID(B7,1,FIND(" ",B7,FIND(" ",B7)+1)),B7)
Regards
Last edited by TMS; 09-09-2011 at 05:44 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Works great! Thanks much!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks