| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Word select from a string
I wish to select a particular word from a string but cannot see a formula to do it. At the moment I am only interested in the first word so coded A1="FRED BLOGGS" =LEFT(A1,FIND(" ",A1)-1) which works fine as long as there is a " " in the string. However this is not always the case so the FIND function returns #VALUE! and messes up the the formatting. I'm sure there is an easier way of doing this so any help would be appreciated. Many thanks. -- bridgjr ------------------------------------------------------------------------ bridgjr's Profile: http://www.excelforum.com/member.php...o&userid=25908 View this thread: http://www.excelforum.com/showthread...hreadid=392844 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto word select | Excel Discussion (Misc queries) | |||
| Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
| Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
| Hyperlink to word document problem | Links and Linking in Excel | |||
Threaded Mode
