Excel Formula

M

Munfarid

Cell A1 contains the value = Abw929acp148ab9520cs6528 i.e.
a1='Abw929acp148ab9520'

the result so required should be:
B1=Abw-929
B2=acp-148
B3=ab-9520
 
N

NBVC

Try:

=REPLACE(LEFT(A1,6),4,0,"-")

=REPLACE(MID(A1,7,6),4,0,"-")

=REPLACE(RIGHT(A1,6),3,0,"-"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top