hi excelers
I need a solution to this question:
what formula would separate-out the single digits from say "2610514117" (in a column)
to
A1 = 2
B1 = 6
C1 = 1
etc...
hi excelers
I need a solution to this question:
what formula would separate-out the single digits from say "2610514117" (in a column)
to
A1 = 2
B1 = 6
C1 = 1
etc...
Assuming original is in A1, then try in B1:
=MID($A1,COLUMNS($A$1:A1),1)+0
copied across...
Last edited by NBVC; 01-28-2010 at 09:33 AM. Reason: added +0 to convert to numbers
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
thanks NBVC
that worked nicely
as you are here, is their any any of compressing a small string of binarys say 30?
or is their any way of compressing digits say 10?
If this is not related to the initial question you should really start a new thread...
Also, I don't understand what you mean.. so you should elaborate in your new thread if you want a solution.
Please mark this one as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks