Formating Cell''s

%3CLINGO-SUB%20id%3D%22lingo-sub-2261297%22%20slang%3D%22en-US%22%3EFormating%20Cell''s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261297%22%20slang%3D%22en-US%22%3E%3CP%3Eso%20I%20have%20this%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22129%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22156px%22%20height%3D%2230px%22%3E100073403705W502%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22156px%22%20height%3D%2230px%22%3E100040703807W500%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22156px%22%20height%3D%2230px%22%3E100041504210W500%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22156px%22%20height%3D%2230px%22%3E100042203604W500%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20i%20need%20them%20to%20look%20like%20this%3C%2FP%3E%3CDIV%3E100%2F02-18-045-03W5%2F00%3C%2FDIV%3E%3CDIV%3Eis%20there%20a%20way%20that%20excel%20can%20do%20this%20for%20me%20easy%20without%20having%20to%20edit%20276%20excel%20lines%20one%20by%20one%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2261297%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

so I have this 

100073403705W502
100040703807W500
100041504210W500
100042203604W500

 

and i need them to look like this

100/02-18-045-03W5/00
is there a way that excel can do this for me easy without having to edit 276 excel lines one by one

 

2 Replies

@Chris1975 

Let's say the values are in A2 and down.

Enter the following formula in B2, then fill down:

 

=LEFT(A2,3)&"/"&MID(A2,4,2)&"-"&MID(A2,6,2)&"-"&MID(A2,8,3)&"-"&MID(A2,11,4)&"/"&RIGHT(A2,2)

@Hans Vogelaar 

 

Thank you So much your a life saver.