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

  • Thread starter Thread starter Loz
  • Start date Start date
L

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
 
=CONCATENATE(LEFT(A2,4),"-",mid(a2,5,999))
(make 999 big enough)
or less typing:
=left(a2,4)&"-"&mid(a2,5,999)
 
Loz,

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

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

John
 
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
 
Thank you all for your invaluable help.
It's always a relief to have quality assistance on hand!
:)

Lauren
 
Back
Top