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

[Alan]

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.

 

[RagDyer]

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!
==============================================


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.

 

[Ken Wright]

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)

 

[~Alan]

I would like to thank you both for your quick responses and the help in solving my
problem.
RagDyer this is the code that solved it =MID($G$1,COLUMN(),1) and thank you.
I gave you both incorrect information and for that I am sorry Mr. Dyer did pick up
on it as I did indicate the use of the TAB key
which did give the clue I meant columns and not Rows.
Once again Thank you and I will try to be more thorough in the future.

 

[Frank Kabel]

Hi Alan
the formula should work. In your example you have hidden some columns
(col. I and J are hidden). So there's nothing missing but only hidden


For your second question:
- Excel displays large numbers in a scientific notation (xxxEnn)
- also you can't enter more than 15 significant digits. Excel does not
suport more than 15 digits. You have to store such values as Text
(enter these numbers with a preceding apostrophe)


--
Regards
Frank Kabel
Frankfurt, Germany

I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a
number will start it at a different column.

When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5
characters show missing the middle eighth and nineth
One would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it
changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code


[Image]

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!
==============================================

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.

I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a number will start it at a different column.
When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5 characters show missing the middle eighth and nineth One
would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code











RagDyer wrote:

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! ==============================================

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.

 

[~Alan]

I guess I am going to have to look for something hidden.
I opened a new work book and sure enough it worked.

Hi Alan
the formula should work. In your example you have hidden some columns
(col. I and J are hidden). So there's nothing missing but only hidden


For your second question:
- Excel displays large numbers in a scientific notation (xxxEnn)
- also you can't enter more than 15 significant digits. Excel does not
suport more than 15 digits. You have to store such values as Text
(enter these numbers with a preceding apostrophe)

--
Regards
Frank Kabel
Frankfurt, Germany

I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a
number will start it at a different column.

When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5
characters show missing the middle eighth and nineth
One would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it
changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code


[Image]








RagDyer wrote:

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!
==============================================

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.



I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a number will start it at a different column.
When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5 characters show missing the middle eighth and nineth One
would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code











RagDyer wrote:

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! ==============================================

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.

 

[~Alan]

I think I have one last question is it possible to only pick up the last
six characters

What I have is an order form that calls for a 6 digit employee number and a
6 digit event
the employee number starts at F12 - K12
and the event is on G12 - G12
I will enter the 12 characters At P3

Hi Alan
the formula should work. In your example you have hidden some columns
(col. I and J are hidden). So there's nothing missing but only hidden


For your second question:
- Excel displays large numbers in a scientific notation (xxxEnn)
- also you can't enter more than 15 significant digits. Excel does not
suport more than 15 digits. You have to store such values as Text
(enter these numbers with a preceding apostrophe)

--
Regards
Frank Kabel
Frankfurt, Germany

I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a
number will start it at a different column.

When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5
characters show missing the middle eighth and nineth
One would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it
changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code


[Image]








RagDyer wrote:

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!
==============================================

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.



I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a number will start it at a different column.
When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5 characters show missing the middle eighth and nineth One
would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code











RagDyer wrote:

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! ==============================================

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.

 

[RagDyeR]

Confusing again Alan!
<<"the employee number starts at F12 - K12">>
Does that mean 6 individual numbers *from* F12 * to * K12?
OR
Does that mean 6 individual numbers at F12 *and* K12?

And the event on G12 - G12 ?!?!?

Anyway, this will take the last six characters in F12,
and add the last six characters in G12, with no space between them.

=RIGHT(F12,6)&RIGHT(G12,6)

If you need them separated, try this:

=RIGHT(F12,6)&" "&RIGHT(G12,6)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I think I have one last question is it possible to only pick up the last
six characters

What I have is an order form that calls for a 6 digit employee number and a
6 digit event
the employee number starts at F12 - K12
and the event is on G12 - G12
I will enter the 12 characters At P3

Hi Alan
the formula should work. In your example you have hidden some columns
(col. I and J are hidden). So there's nothing missing but only hidden


For your second question:
- Excel displays large numbers in a scientific notation (xxxEnn)
- also you can't enter more than 15 significant digits. Excel does not
suport more than 15 digits. You have to store such values as Text
(enter these numbers with a preceding apostrophe)

--
Regards
Frank Kabel
Frankfurt, Germany

I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a
number will start it at a different column.

When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5
characters show missing the middle eighth and nineth
One would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it
changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code


[Image]








RagDyer wrote:

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!
==============================================

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.



I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a number will start it at a different column.
When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5 characters show missing the middle eighth and nineth One
would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code











RagDyer wrote:

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! ==============================================

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.

 

[~Alan]

P3 the number will maybe 12345002S/F
in (F12) 1 (G12) 2 (H12) 3 ( I12) 4 ( J12) 5 (K12) 6
(F13) 0 (G13) 0 (H13) 2 ( I13) S ( J13) / (K13) F

Confusing again Alan!
<<"the employee number starts at F12 - K12">>
Does that mean 6 individual numbers *from* F12 * to * K12?
OR
Does that mean 6 individual numbers at F12 *and* K12?

And the event on G12 - G12 ?!?!?

Anyway, this will take the last six characters in F12,
and add the last six characters in G12, with no space between them.

=RIGHT(F12,6)&RIGHT(G12,6)

If you need them separated, try this:

=RIGHT(F12,6)&" "&RIGHT(G12,6)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I think I have one last question is it possible to only pick up the last
six characters

What I have is an order form that calls for a 6 digit employee number and a
6 digit event
the employee number starts at F12 - K12
and the event is on G12 - G12
I will enter the 12 characters At P3

Hi Alan
the formula should work. In your example you have hidden some columns
(col. I and J are hidden). So there's nothing missing but only hidden


For your second question:
- Excel displays large numbers in a scientific notation (xxxEnn)
- also you can't enter more than 15 significant digits. Excel does not
suport more than 15 digits. You have to store such values as Text
(enter these numbers with a preceding apostrophe)

--
Regards
Frank Kabel
Frankfurt, Germany

I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a
number will start it at a different column.

When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5
characters show missing the middle eighth and nineth
One would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it
changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code


[Image]








RagDyer wrote:

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!
==============================================

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.




I am having one more problem
=MID($G$1,COLUMN(),1)
=MID($G$1,COLUMN()-1,1) I understand that by adding a minus sign and
then a number will start it at a different column.
When I try to use it this way =MID($U$14,COLUMN()-1,1) and I enter 9
or
more characters only the first 7 show.then if you continue only the
next 5 characters show missing the middle eighth and nineth One
would think that it should carry unlimited amount of characters

Also why cant i enter 123456789123456789 in a cell that is formated
general it changes to1.23457E+17
and if i format it to number it will change to 123456789123456000

'w h y d o e s n t h I s w o r k no code
w h y d o e s h i s w o k n b o whydoesnthisworknbow
1 2 3 4 5 6 7 1 2 3 4 5 0 0 0 123456789123456000
'1 6 9 2 8 0 - 0 0 1 G A S 169280-001GAS no code











RagDyer wrote:

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! ==============================================

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.