Separating text into seperate fields

[vanced]

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)

 

[Mike H]

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

 

[Mike H]

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

 

[David Biddulph]

=LEFT(A1,FIND(".",A1))
=RIGHT(A1,LEN(A1)-FIND(".",A1))