In an adjacent cell, put this formula:

=LEFT(A2,2)&"-"&RIGHT(A2,4)

This assumes their all the same 6-digit length.
--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Jennifer V." wrote:

aa1234
bb1234
cc4321
dd0987
mj5830

It needs to have a space or a symbol between the 2 letters and the 4 numbers.

Thanks!