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 &#39;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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to