Re: resequence with a prefix

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

Try this formula:

=LEFT(A1,4)&TEXT(MID(A1,5,1000)+1,"000")

the Left (a1,4) assumes that you use the 4 character string "prt:". If
you use a longer / shorter string, just adjust the left / mid
functions accordingly.


On Aug 9, 2:38 pm, raulavi <raul...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
excel 2007: have 1 col with many rows, each cell has a prefix prt:000 , need
to sequence all row in that col as prt:001,prt:002...and so on... any ideas
how?

TIA


.

Relevant Pages

  • Re: Database design
    ... What is the character string? ... e.g., as a sequence of characters, as ... a sequence of words (for indexing and word analysis), ... But it can also refer to the relation - unless, ...
    (comp.databases.theory)
  • Re: printf("%ls")
    ... printfprints a multibyte character string to stdout as a sequence ... and prints it out as a sequence of bytes. ...
    (comp.lang.c)
  • Re: How to assign long to character array and later extract it
    ... store a character string in decimal, a sequence of bytes, a sequence ... Keith Thompson kst-u@xxxxxxx ...
    (comp.lang.c)
  • Re: 8 bit character string to 16 bit character string
    ... character string to a 16 bit character string? ... All that the C standard knows about char is that it is a -minimum- ... and copy each member of a char array in the corresponding position in ... each of which may be part of a multi-byte sequence, ...
    (comp.lang.c)