Welcome Guest
You last visited December 4, 2016, 5:20 pm
All times shown are
Eastern Time (GMT-5:00)

# Formula help

Topic closed. 4 replies. Last post 6 years ago by frenchie.

 Page 1 of 1
Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
 Posted: July 3, 2010, 5:53 pm - IP Logged

Hi,

I need help with a formula that will extract digits from a 8 digits number ?

Exemple I have in cell : A1 the number : 15624298 and I need a formula or formulas that will put each digit in different cell ? thank you.

A1 : 15624298

will result in cells :

B1 : 1

C1 : 5

D1 : 6

E1 : 2

F1 : 4

G1 : 2

H1 : 9

I1 : 8

Thank you.            Frenchie.

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5893 Posts
Offline
 Posted: July 3, 2010, 6:16 pm - IP Logged

Hi,

I need help with a formula that will extract digits from a 8 digits number ?

Exemple I have in cell : A1 the number : 15624298 and I need a formula or formulas that will put each digit in different cell ? thank you.

A1 : 15624298

will result in cells :

B1 : 1

C1 : 5

D1 : 6

E1 : 2

F1 : 4

G1 : 2

H1 : 9

I1 : 8

Thank you.            Frenchie.

Put cursor in A1, find Text to Columns menu, usually it's under the data menu.

Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
 Posted: July 3, 2010, 6:34 pm - IP Logged

Thanks CARBOB,

I tried but it doesn't work,

I realy NEED A FORMULA for this one, I need the number to stay as a number and not a text.

I know someone out there has the answer !!!  Thanks again CARBOB.

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: July 3, 2010, 7:30 pm - IP Logged

This should work provided it's used for 8 digit numbers only.

Play around with it and you can get it for other digit sizes.

If the data is in A1, first paste this into B1.

After that, copy contents of B1 and paste into the other cells.

Excel will handle the column and row changes automagically.

=VALUE(MID(TEXT(\$A1,"00000000"),CELL("col",B1)-CELL("col",\$A1),1))

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.
Use at your own risk.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
 Posted: July 3, 2010, 10:32 pm - IP Logged

Thank you very much JADELottery, it work perfectly.

Serge.

 Page 1 of 1