• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Formula Annoyances > TEXT FORMULA ANNOYANCES

TEXT FORMULA ANNOYANCES

PARSE FIXED-LENGTH SUBSTRINGS

The Annoyance:

I work for a car dealership, so I work with a lot of Vehicle Identification Numbers (VINs). A VIN is 17 characters long and contains information about the car maker, the car model, the year it was made, and so on. The dealership's VIN tracking software writes the VIN of every car we have on the lot to a text file. What I want to do is break down each car's VIN (a representative sample is shown in Figure 3-22) into meaningful chunks. Can Excel do that?

Figure 3-22. You can use this data's pattern to separate it into its component parts.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint