Thread: custom format cell with text and numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default custom format cell with text and numbers
In a helper cell:

=LEFT(A1,2) & "-" & MID(A1,3,4) & "-" & MID(A1,6,4) & "-" & RIGHT(A1,1)

--
Gary's Student


"maryj" wrote:

Client needs to change existing values from AA111122223 to AA-1111-2222-3. Is
there any way to do this with custom formatting? Or what other options might
there be? Thanks!
--
maryj
Reply With QuoteReply With Quote