Separating the number in A2 into digits, so that each of cells B2:G2 will contain one digit.
Solution: Using the MID and COLUMN functions, as follows: =MID($A2,COLUMN()-1,1) Separating a Number Into Digits ajaY :) On Jun 22, 5:51 pm, mageshwaran jayaraman <macwa...@yahoo.co.in> wrote: > Hi, > > I am Maheshwaran J from Phuket Islands-Thailand > > Tip to trace dependent from other sheet and file - Control and [ > > In case you have a figure which is a formula derived from some other cell > in same sheet or some other sheet in same file or some cell in some other > file altogether, then press Control and [. > Though the formula bar shows you the complete path as to from which cell of > which sheet and file name, but by pressing these, the cursor moves directly > to that cell of that sheet. > This is useful where in an excel file you have one main sheet, in which all > the values are derived from different sheets. And to recheck as to whether > the correct figures have come under correct headings, one can use this tip > from the said main sheet. Please check the attached sheet for further > clarification and in case still confused, please free to write to me. > Thanx 'n' rgds, > Maheshwaran J. > > On 6/21/09, Ayush <jainayus...@gmail.com> wrote: > > Dear Members, > > Thanks for your great response in the Week 25 competition. It was > again great learning for the members of the group. > Let us begin week # 26 quiz with the more spirit. This is last chance > for you to be eligible for June month competition.The winner of week # > 25 will be declared soon. Keep watching this Space...... > > Last Date of Submission of tips : 28th June 2009. > > PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE > CONSIDERED FOR PRIZES. > DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS. > > You need to submit your name, Subject & the details of tips and > tricks. > DO let me know if you need any clarifications. > > Let me begin by submitting the first tip for this week competition. > --------------------------------------------------------------------------------------------------------------------------------------------------- > Name : Ayush Jain > Subject : Format Painter > Detail : The little "format painter" is the most useful button in > Excel. It looks like a paintbrush and is grouped with the > cut,copy,paste buttons. Basically highlight a cell with the formating > that you want, click the button, and then highlight cell(s) that you > want to just paste the format. HUGE time saver! > > Who is next ???????????????????? > > ICC World Twenty20 England '09 exclusively on YAHOO! > CRICKEThttp://cricket.yahoo.com > > Book1.xls > 28KViewDownload --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---