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