Member Avatar for Leevisse

Hi guys,

i need a help with separating characters by using dash in excel 2007.

Example,

Before: 12345678901234567890 After: 1234-5678-9012-3456-7890

Can anyone help me tell me how to do it in excel? I need to split over 5,000 columns with different characters.

Thanks!


Leevisse

  • 2 Contributors
  • 1 Reply
  • 90 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Dilton1958
Member Avatar for Dilton1958

You may use Mid(function) as below:
Suppose your number is in A1, in A2 or the last cell of the row, input formula = Mid(A1,0,4), then on the next cell = (A1,5,4) like that till last digit. Then next cell would contain formula = A2&"-"&A3&"-"&A4&"" etc. If you can send me your emailID i will send a sample worksheet

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.