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

=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

With a formula
=LEFT(I22,FIND("-",I22)-2)

a macro

mr=range("i22")
mr.value=LEFT(mr,FIND("-",mr)-2)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DaveM" wrote in message
. uk...
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

Hi Dave

Works a treat

Thanks for your fast reply

All the best

DaveM


"Dave Peterson" wrote in message
...
=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

a macro

mr=range("i22")
mr.value=LEFT(mr,FIND("-",mr)-2)

I believe it should be more like this...

Set mr = Range("B1")
mr.Offset(0, -1).Value = Left(mr.Value, InStr(mr.Value, "-") - 2)

Rick