Edit numerous cell entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have numerous cell entries all the same length ie:( 21071303129W300)
I need to edit the entries with slashes and dashes as shown here
21/07-13-031-29W3/0...how can I acomplish this in excel without manually
editing each entry cell by cell?
 
One way:

=LEFT(A1,2)&"/"&MID(A1,3,2)&"-"&MID(A1,5,2)&"-"&MID(A1,7,3)&"-"&MID(A1,10,3)&"/"&RIGHT(A1,3)

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alter Text in 900 cell entries 2
Hide columns based on row values 2
How sum numbers in the same cell and entry 2
Handling cells with multiple data entries 2
cell to have comma-delimited values based on text 8
how do i put color in a cell based on data in a second cell 5
Making name of worksheet a function 1
VLOOKUP, a table with text and numerics 7

Back
Top