From Column A get Text from Colum B

[DaveM]

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]

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

 

[Don Guillett]

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

a macro

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

 

[DaveM]

Hi Dave

Works a treat

Thanks for your fast reply

All the best

DaveM

 

[Rick Rothstein \(MVP - VB\)]

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