Separating text into seperate fields

  • Thread starter Thread starter vanced
  • Start date Start date
V

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)
 
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
 
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
 
Back
Top