Cell A1 = 123456
Now I need to find each number in different cell. It may be
Cell A2 = 1
Cell A3 = 2
Cell A4 = 3
Cell A5 = 4
Cell A6 = 5
I am new in excel so any who can help I will be very grateful to him/her.
Cell A1 = 123456
Now I need to find each number in different cell. It may be
Cell A2 = 1
Cell A3 = 2
Cell A4 = 3
Cell A5 = 4
Cell A6 = 5
I am new in excel so any who can help I will be very grateful to him/her.
Write this in A2
Formula:Please Login or Register to view this content.
And pull down
Thanks zbor. Now Its working. If I want to find from right which function I have to call
Cell A1 = 123456
Cell A2 = 6
Cell A3 = 5
Cell A4 = 4
....
Use this:
Formula:Please Login or Register to view this content.
To zbor: Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks