Welcome Guest [Log In] [Register]
Assalamoalaikum, We hope you will enjoy your visit here.

Join our community!

If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Separating a number into digits
Topic Started: Jul 20 2007, 02:43 PM (603 Views)
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Separating a Number Into Digits

Problem:

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)
Offline Profile Quote Post Goto Top
 
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Posted Image
Offline Profile Quote Post Goto Top
 
Deleted User
Deleted User

MASHALLAH g boht kaam ke cheez share ke aap nay thanks
ALLAH tallah aap ko jazahay khair dain ameen
Quote Post Goto Top
 
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
thanks
Offline Profile Quote Post Goto Top
 
Deleted User
Deleted User

You are welcome janab ........... aur bhi too batain g :)
Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Roshnee · Next Topic »
Add Reply