Excel 07 formating 17 cells "Need Formula"

		Microsoft Office Forums > Microsoft Excel > Excel
Excel 07 formating 17 cells "Need Formula"

05-30-2010, 11:29 AM

ConneXionLost ConneXionLost is offline

Windows XP Excel 07 formating 17 cells "Need Formula"

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

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,

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wierd symbols inplace of "space", "indentation" etc	aka.bhagvanji	Word	5	02-16-2012 11:50 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM
Excel pivot table into an MS Word Doc "office 2007"	wmarsh3561	Excel	1	01-09-2010 08:03 PM
How do I change the "and" to "or" with multiple Rules (and Alerts)?	bschimmel	Outlook	0	11-16-2009 05:26 AM
Saving only "DATA" on excel? No white bottom?	jrasche2003@yahoo.com	Excel	0	08-07-2006 09:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:51 PM.