RE: How do I separate a text value with dashes?

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

One way
Have a look at Data>Text to Columns. You test is delimited and the delimiter
is other "-" select your destination cell
HTH


"Phil" wrote:

> Hello,
>
> I have a column (called Tract Number) that contains a column with a 11
> character number (BTW, it really isn't a number, if that helps), such as this
> one: 7-5-029-001. The number will ALWAYS have this format, and will ALWAYS
> contain 11 characters.
>
> The first number (7 in this case) is for Township, the second (5) for Range,
> the third (029) for Section, and the fourth (001) for Tract.
>
> I have 4 new columns with Township, Range, Section, and Tract to the
> immediate right of the Tract Number column. Here is my question:
>
> How can I break up the 11 characters so that they will automatically
> populate the appropiate columns?
>
> TIA for your reply.
.

Relevant Pages

  • How do I separate a text value with dashes?
    ... I have a column (called Tract Number) that contains a column with a 11 ... character number (BTW, it really isn't a number, if that helps), such as this ... The first number is for Township, the second for Range, ... How can I break up the 11 characters so that they will automatically ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Lengthy merge code
    ... Do any of your data fields contain any of the delimiter characters (i.e. the ... the chances are that the problem has nothing to do with memory. ... proprietary software package - I don't dare name it - and the merge ...
    (microsoft.public.word.mailmerge.fields)
  • Re: URLScan
    ... You state that "The delimiter of the log file is defined by W3C ... whitespace, not space characters: ...
    (microsoft.public.inetserver.iis.security)
  • Re: WORD factors Was: Re: RFD: Legacy Wordset
    ... delimiters other than BL while available to implementers, ... |characters shall be treated the same as the space character. ... character set are defined in this Standard as control characters. ... If the delimiter is the space character, hex 20, control characters ...
    (comp.lang.forth)
  • Re: [man bash] section "Word Splitting" - IFS
    ... > sing explanation of IFS varible in EXPANSION section, ... then any sequence of IFS characters serves to delimit words. ... >> also treated as a delimiter. ...
    (comp.unix.shell)