| 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: |
| Separating a number into digits | |
|---|---|
| Tweet Topic Started: Jul 20 2007, 02:43 PM (603 Views) | |
| Ahmaq | Jul 20 2007, 02:43 PM Post #1 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
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) |
![]() |
|
| Ahmaq | Jul 20 2007, 02:46 PM Post #2 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
Posted Image |
![]() |
|
| Deleted User | Jul 23 2007, 09:34 AM Post #3 |
|
Deleted User
|
MASHALLAH g boht kaam ke cheez share ke aap nay thanks ALLAH tallah aap ko jazahay khair dain ameen |
|
|
| Ahmaq | Jul 28 2007, 07:45 PM Post #4 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
thanks |
![]() |
|
| Deleted User | Aug 1 2007, 12:03 AM Post #5 |
|
Deleted User
|
You are welcome janab ........... aur bhi too batain g :) |
|
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Roshnee · Next Topic » |








5:32 AM Jul 11