Split off numbers

I have about 100 sets of numbers in column I,i.e. 1513-345678, and I want to
pull off the first four and the "-" from the rest of the set and place them
in column H. What is a formula that will do that for me?

Mike Rogers

Hi!

Are there always 4 digits followed by a dash ?

=LEFT(A1,5)

Biff

"Mike R" <[email protected]> wrote in message
news:[email protected]...
>I have about 100 sets of numbers in column I,i.e. 1513-345678, and I want
>to
> pull off the first four and the "-" from the rest of the set and place
> them
> in column H. What is a formula that will do that for me?
>
> Mike Rogers

Hi Mike,

A1: 1513-345678

B1: =LEFT(A1,4)


---
Regards,
Norman



"Mike R" <[email protected]> wrote in message
news:[email protected]...
>I have about 100 sets of numbers in column I,i.e. 1513-345678, and I want
>to
> pull off the first four and the "-" from the rest of the set and place
> them
> in column H. What is a formula that will do that for me?
>
> Mike Rogers

Hi, Mike,

> B1: =LEFT(A1,4)

Change 4 to 5.

I missed the dash (-)!

---
Regards,
Norman



"Norman Jones" <[email protected]> wrote in message
news:%[email protected]...
> Hi Mike,
>
> A1: 1513-345678
>
> B1: =LEFT(A1,4)
>
>
> ---
> Regards,
> Norman
>
>
>
> "Mike R" <[email protected]> wrote in message
> news:[email protected]...
>>I have about 100 sets of numbers in column I,i.e. 1513-345678, and I want
>>to
>> pull off the first four and the "-" from the rest of the set and place
>> them
>> in column H. What is a formula that will do that for me?
>>
>> Mike Rogers
>
>

Thanks for the response. You both nailed it for me. Some things that are so
simple can be so difficult to see. Thanks again.

Mike Rogers

"Mike R" wrote:

> I have about 100 sets of numbers in column I,i.e. 1513-345678, and I want to
> pull off the first four and the "-" from the rest of the set and place them
> in column H. What is a formula that will do that for me?
>
> Mike Rogers