Edit numerous cell entries

R

raywood

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?
 
P

PCLIVE

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

Space at end of multi page list to accommodate new entries 1
Alter Text in 900 cell entries 2
Hide columns based on row values 2
Merging from an Excel file with graphics 1
Word macro that can call cells out of Excel for a find and replace 0
Remove date format? 3
VLOOKUP, a table with text and numerics 7
Using Data Validation via an array to stop manual entries - possib 4

Top