#1
|
|||
|
|||
Excel 07 formating 17 cells "Need Formula"
Hi I am working on a project that I have to enter a Vehicle 17 digit Vin #,Is there a formula to format the cursor to shift to the right on 17 individual cells,if so I need to make a formula to automatically move to the next cell on the right after I type in the letter or number on the selected cells without having to use the right shift arrow is this possible excel 2007 . Thanks Raner. |
#2
|
||||
|
||||
Assuming you enter the entire VIN in cell A2, then paste this formula:
Code:
=MID($A2,COLUMN()-1,1) Cheers, |
#3
|
|||
|
|||
Thanks for the comeback ConieXionLost I'll give a try, Raner.
|
|
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 |