Thread: insert "-" as fourth character in number string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 620
Default insert "-" as fourth character in number string
=LEFT(A1,3)&"-"&RIGHT(A1,LEN(A1)-3)
--
David Biddulph

"cursednomore" wrote in message
...
I have 8700 rows of numerical data, and I would like to insert a "-" as the
fourth character from the left in each cell, so that 101394 becomes
101-394,
and 1011001403 becomes 101-1001403. Any help would be greatly appreciated.


Reply With QuoteReply With Quote