Putting a "-" in the middle of a part number

[Loz]

Hi

I have a part number and I need to put a "-" four characters from the left.

So far I have:
=CONCATENATE(LEFT(A2,4),"-",)

but I don't know what to put in the second half to add the other half of the
part number.

I'd appreciate any help! Maybe there is an easier way to achieve this.

Thank you
Lauren

 

[Vasant Nanavati]

One way:

=SUBSTITUTE(A2,LEFT(A2,4),LEFT(A2,4)&"-")

 

[Dave Peterson]

=CONCATENATE(LEFT(A2,4),"-",mid(a2,5,999))
(make 999 big enough)
or less typing:
=left(a2,4)&"-"&mid(a2,5,999)

 

[John Wilson]

Loz,

Probably a lot of ways to do this. Here's one:

=LEFT(A1,4)&"-"&MID(A1,5,LEN(A1)-5)

John

 

[John Wilson]

Loz,

Didn't notice that you were working with A2.
Just change the reference on what I originally gave you:

=LEFT(A2,4)&"-"&MID(A2,5,LEN(A2)-5)

John

 

[Loz]

Thank you all for your invaluable help.
It's always a relief to have quality assistance on hand!


Lauren