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
(E-Mail Removed)
"DaveM" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =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