| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separating text into seperate fields
I have several long strings of text in which I would like to separate the
first sentance ending in ". " into another field. Which function would I need to use. Any help would be greatly appreciated. Example: (1) Conformance. Cylinders shall comply with DOT specifications and shall be..... (1) Conformance. (cell 1) Cylinders shall comply with DOT specifications and shall be.....(cell 2) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separating text into seperate fields
Hi,
To extract the first bit try =LEFT(A1,FIND(".",A1,1)-1) and the second bit =MID(A1,FIND(".",A1,1)+2,LEN(A1)) For the second bit you may have to adjust the +2 to allow for whether the space is really there after the full stop. Mike "vanced" wrote: I have several long strings of text in which I would like to separate the first sentance ending in ". " into another field. Which function would I need to use. Any help would be greatly appreciated. Example: (1) Conformance. Cylinders shall comply with DOT specifications and shall be..... (1) Conformance. (cell 1) Cylinders shall comply with DOT specifications and shall be.....(cell 2) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separating text into seperate fields
Changed my mind about the second one you can ignore the comment on spaces,
use this =TRIM(MID(A1,FIND(".",A1,1)+1,LEN(A1))) Mike "vanced" wrote: I have several long strings of text in which I would like to separate the first sentance ending in ". " into another field. Which function would I need to use. Any help would be greatly appreciated. Example: (1) Conformance. Cylinders shall comply with DOT specifications and shall be..... (1) Conformance. (cell 1) Cylinders shall comply with DOT specifications and shall be.....(cell 2) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separating text into seperate fields
=LEFT(A1,FIND(".",A1))
=RIGHT(A1,LEN(A1)-FIND(".",A1)) -- David Biddulph "vanced" wrote in message ... I have several long strings of text in which I would like to separate the first sentance ending in ". " into another field. Which function would I need to use. Any help would be greatly appreciated. Example: (1) Conformance. Cylinders shall comply with DOT specifications and shall be..... (1) Conformance. (cell 1) Cylinders shall comply with DOT specifications and shall be.....(cell 2) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating text | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| separating fields | Charts and Charting in Excel | |||
| separating fields | Charts and Charting in Excel | |||
| Separating text | Excel Worksheet Functions | |||
Hybrid Mode
