Re: Excel Function?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You can split it with Data/ Text to Columns/ Fixed width

Another option is to use
=LEFT(A2,2) assuming that the input is a text string, not a number
formatted as 000000. [ If the latter, then try =LEFT(TEXT(A2,"000000"),2) ]
=MID(A2,3,2)
=RIGHT(A2,2)
If you want the output strings to become numbers, put a double unary
minus -- in front of the LEFT, MID, or RIGHT.
--
David Biddulph

"Kent" <Kent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6A46BDDA-E004-4D2B-893E-DBFE6B7DF760@xxxxxxxxxxxxxxxx
I am looking for a way to split the data in one cell into multiple values
that can each be referenced from another cell. For example, the value of
my
data cell is "001122". The first two digits represent one value, the
second
two digits represent the second value, and the last two digits represent
the
third value. Now I need to reference each value independent of the other
two.
So, I want to return the value of the first two digits only, or the second
two digits only, or the last two digits only. Is there any way to
accomplish
what I'm after?

Thank you,

Kent


.

Relevant Pages

  • Re: Complex Specified Information - Pitman Formula
    ... Therefore a significant match between a reference and a test ... string is good evidence of non-random production. ... and there are no finite algorithms to compute their digits. ... probabilities of the different symbols the information source can produce. ...
    (talk.origins)
  • Re: How to convert extra long strings into their equivalent Hex Strings in VBA (Word 2K)
    ... numbers (upto 18 digits max) into its equivalent Hex String ... Public Function ExpressServiceCode(ByVal ServiceTag As String) As String ... 'the number dblTemp in the specified base, ... Dim lngTemp As Long ...
    (microsoft.public.vb.general.discussion)
  • Re: BigNum -- Floating Point
    ... The 'N' is the number of decimal digits. ... The internal representation is really just a string of bits. ... the number of shifts for various multiples of ten: ... The 'exponent' is very closely related to ...
    (comp.programming)
  • Patterns in pi, copyright law, and philosophy
    ... Whether the offset of a string found in pi can be used as a form on ... then calculate how many digits of pi one would need to raise the ... "An infinite series of numbers is not an exhaustive set of numbers. ... finite string of digits occurs within the decimal expansion of pi, ...
    (sci.math)
  • Re: Patterns in pi, copyright law, and philosophy
    ... The digits of pi are widely believed to be "normal", in the sense that every n digit combination of digits is equally likely, and pass all reasonable tests of randomness. ... The mean length of the offset must at least be equal or greater than the length of the string you are looking for. ... Pi has an infinite representation as a decimal. ... finite string of digits occurs within the decimal expansion of pi, ...
    (sci.math)