Thread: make "F51668H200AU" into "F5166-8H200AU"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default make "F51668H200AU" into "F5166-8H200AU"
Try:

=LEFT(A1,5) & "-" & RIGHT(A1,LEN(A1)-5)
--
Gary's Student


"fitzu" wrote:

I need to add a - after the first 5 digits can get it to work with numbers
but not with letters & numbers
Reply With QuoteReply With Quote