=search(" - ",b1)
will return the position of that " - " string.

So
=left(b1,search(" - ",b1)-1)
will return the beginning of that string in B1

If there's a chance that there's no " - " in that string, you can avoid the
error and bring back everything with a formula like:
=left(b1,search(" - ",b1&" - ")-1)


DaveM wrote:

Hi

I have text cells in column B, The text cells in column B start with some
word or words followed by a space-space then the rest of text.

Example:

Cell B1

Analogue (Analog) circuit - An electronic circuit in which an electrical
value (usually voltage or current, but sometimes frequency, phase)
represents something in the physical world.The magnitude of the electrical
value varies with with the intensity of an external physical quantity.

How could I get "Analogue (Analog) circuit" and put it in column A1.

There is lot of cells in the columns and I'd like to go down one at a time,
and move these to column A.

Thanks in advance

Dave

--

Dave Peterson