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)

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)

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)

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)