Thread: Import underscore in coding every after 2 digits
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Import underscore in coding every after 2 digits
=SUBSTITUTE(TEXT(A1,"00-00-00-00"),"-","_")


"Manos" wrote:

Dear All

I have a fixed coding with 8 digits. (ie: 40000000).
I need to change this and split it importing underscore every two digits in
order to look like (ie.: 40_00_00_00)
Any clever way to do it for 25000 rows?

Thanks in advance for your time.... :)
Reply With QuoteReply With Quote