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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Hi Mike,

A1: 1513-345678

B1: =LEFT(A1,4)


---
Regards,
Norman



"Mike R" wrote in message
...
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