From Column A get Text from Colum B
 

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

From Column A get Text from Colum B
 

=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

From Column A get Text from Colum B
 

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

From Column A get Text from Colum B
 

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

From Column A get Text from Colum B
 

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