Microsoft Office Forums - View Single Post - [Solved] Excel 07 formating 17 cells "Need Formula"

Thread: [Solved] Excel 07 formating 17 cells "Need Formula"

View Single Post

Old

05-30-2010, 11:29 AM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

Assuming you enter the entire VIN in cell A2, then paste this formula:

Code:

=MID($A2,COLUMN()-1,1)

in cell B2, and autofill out to cell R2.

Cheers,

Reply With Quote