Re: XL 2000 six digit number and separate it into six separate cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 03/27/04 

Date: Sat, 27 Mar 2004 10:41:22 -0000

Note though, that if the ranges are *exactly* as the OP has stated (and they may
well be incorrect), then the formula in A7 if this really wasn't meant to be A6,
will need to be =MID($G$1,ROW()-1,1), or as it is having to be edited anyway
just =MID($G$1,6,1) or =RIGHT($G$1)

Any of these methods though will return a text string, so dependent on what you
want to do with the data, you may want to coerece them back to numeric, so you
could use a double unary to do that, eg:-

=--MID($G$1,ROW(),1)
=--MID($G$1,ROW()-1,1)
=--RIGHT($G$1) 

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
              Sys Spec - Win XP Pro /  XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"RagDyer" <ragdyer@cutoutmsn.com> wrote in message
news:%23t4iaH6EEHA.1368@TK2MSFTNGP11.phx.gbl...
> I really don't understand what you're trying to do, but you can enter this
> formula in A1, and copy it down to A6 (or more or less), and each cell will
> return the individual figures, in sequence, of characters entered in G1.
>
> =MID($G$1,ROW(),1)
>
> However, since you mentioned "tab0", "tab8", and tab generally moves to the
> right, across the columns, you may *not* have meant going down column A, but
> across, from A1.
>
> If that be the case, this will fill row1, starting at A1, with the same
> individual figures in sequence, from G1:
>
> =MID($G$1,COLUMN(),1)
> -- 
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Alan" <methane@adelphia.net> wrote in message
> news:4064CBCC.7CDF1779@adelphia.net...
> windows XP XL 2000
>     In G1 I enter a 6 digit number.
>         Question can XL take that six digit number and separate it into
> six separate cells
>
> as in   G1 082961  then A1 0  A2 8 A3 2 A4 9 A5 6 A7 1
> Reason I have several employees with different numbers and I find it
> time consuming
> to 0tab 8tab 2tab 9tab 6tab 1tab I know that I can make a macro with
> each number to copy and past
> anyway i anyone out there understands what I am asking and if it can be
> done I will greatly appreciate it.
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004

Relevant Pages