| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from the beginning of a text string
I want to extract a series of characters from the beginning of a text string,
before the first space, for example R070056-01a blah blah blah But sometimes its the first 7 or 9 or 10 or 11 characters it varies Can someone please let me know of a formula to extract the data to the first space? Many thanks Cassie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract from the beginning of a text string
Try,
=TRIM(LEFT(A1,FIND(" ",A1))) Mike "Cassie" wrote: I want to extract a series of characters from the beginning of a text string, before the first space, for example R070056-01a blah blah blah But sometimes its the first 7 or 9 or 10 or 11 characters it varies Can someone please let me know of a formula to extract the data to the first space? Many thanks Cassie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract from the beginning of a text string
Mike
many thanks - that works a treat Cassie "Mike H" wrote: Try, =TRIM(LEFT(A1,FIND(" ",A1))) Mike "Cassie" wrote: I want to extract a series of characters from the beginning of a text string, before the first space, for example R070056-01a blah blah blah But sometimes its the first 7 or 9 or 10 or 11 characters it varies Can someone please let me know of a formula to extract the data to the first space? Many thanks Cassie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract from the beginning of a text string
Glad I could help
Mike "Cassie" wrote: Mike many thanks - that works a treat Cassie "Mike H" wrote: Try, =TRIM(LEFT(A1,FIND(" ",A1))) Mike "Cassie" wrote: I want to extract a series of characters from the beginning of a text string, before the first space, for example R070056-01a blah blah blah But sometimes its the first 7 or 9 or 10 or 11 characters it varies Can someone please let me know of a formula to extract the data to the first space? Many thanks Cassie |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract from the beginning of a text string
=LEFT(A1,SEARCH(" ",A1)-1)
Regards, Stefi €˛Cassie€¯ ezt Ć*rta: I want to extract a series of characters from the beginning of a text string, before the first space, for example R070056-01a blah blah blah But sometimes its the first 7 or 9 or 10 or 11 characters it varies Can someone please let me know of a formula to extract the data to the first space? Many thanks Cassie |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract from the beginning of a text string
=LEFT(A1,FIND(" ",A1))
If this post helps click Yes --------------- Jacob Skaria "Cassie" wrote: I want to extract a series of characters from the beginning of a text string, before the first space, for example R070056-01a blah blah blah But sometimes its the first 7 or 9 or 10 or 11 characters it varies Can someone please let me know of a formula to extract the data to the first space? Many thanks Cassie |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract from the beginning of a text string
With your text in A1, use this: =LEFT(A1,SEARCH(" ",A1)-1) Hope this helps. Pete Cassie;294969 Wrote: I want to extract a series of characters from the beginning of a text string, before the first space, for example R070056-01a blah blah blah But sometimes its the first 7 or 9 or 10 or 11 characters it varies Can someone please let me know of a formula to extract the data to the first space? Many thanks Cassie -- Pete_UK ------------------------------------------------------------------------ Pete_UK's Profile: http://www.thecodecage.com/forumz/member.php?userid=205 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82436 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract text from string | Excel Worksheet Functions | |||
| Extract text from a string | Excel Worksheet Functions | |||
| Extract text string using MID | Excel Worksheet Functions | |||
| Extract text from String | Excel Worksheet Functions | |||
| Removing numbers from the beginning of a text string | Excel Worksheet Functions | |||
Hybrid Mode
