software

I have a two part number for tracking delivery notes, separated by a slash
and each number increasing sequentially eg 8987/010942, 8988/010943 etc. How
can I do this automatically? Also Invoice Numbers eg ms/0988/06, ms/0989/06
etc.

Thanks.
Try this:
=LEFT(A1,SEARCH(quot;/quot;,A1)-1) 1amp;quot;/quot;amp;TEXT(RIGHT(A1,LEN(A1)-SEARCH(quot;/quot;,A1)) 1,quot;000000quot;)

HTH
--
AP

quot;Melquot; gt; a écrit dans le message de news:
...
gt;I have a two part number for tracking delivery notes, separated by a slash
gt; and each number increasing sequentially eg 8987/010942, 8988/010943 etc.
gt; How
gt; can I do this automatically? Also Invoice Numbers eg ms/0988/06,
gt; ms/0989/06
gt; etc.
gt;
gt; Thanks.
gt;
gt;
Hi - sorry I failed! It returns #VALUE! Not sure what that means. I
should've maybe mentioned the numbers go down in a column? I'm a relatively
new user so appreciate your help!

quot;Ardus Petusquot; wrote:

gt; Try this:
gt; =LEFT(A1,SEARCH(quot;/quot;,A1)-1) 1amp;quot;/quot;amp;TEXT(RIGHT(A1,LEN(A1)-SEARCH(quot;/quot;,A1)) 1,quot;000000quot;)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Melquot; gt; a écrit dans le message de news:
gt; ...
gt; gt;I have a two part number for tracking delivery notes, separated by a slash
gt; gt; and each number increasing sequentially eg 8987/010942, 8988/010943 etc.
gt; gt; How
gt; gt; can I do this automatically? Also Invoice Numbers eg ms/0988/06,
gt; gt; ms/0989/06
gt; gt; etc.
gt; gt;
gt; gt; Thanks.
gt; gt;
gt; gt;
gt;
gt;
gt;

Enter your initial value in A1:
8987/010942
Enter my formula in A2:
=LEFT(A1,SEARCH(quot;/quot;,A1)-1) 1amp;quot;/quot;amp;TEXT(RIGHT(A1,LEN(A1)-SEARCH(quot;/quot;,A1)) 1,quot;000000quot;)
You should get the expected result of:
8988/010943
You can now drag down my formula to get the following sequence numbers.

If your initial value is no t in A1 but in any other cell, just replace A1
with that other cell's address in my formula.

HTH
--
AP

quot;Melquot; gt; a écrit dans le message de news:
...
gt; Hi - sorry I failed! It returns #VALUE! Not sure what that means. I
gt; should've maybe mentioned the numbers go down in a column? I'm a
gt; relatively
gt; new user so appreciate your help!
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt;gt; Try this:
gt;gt; =LEFT(A1,SEARCH(quot;/quot;,A1)-1) 1amp;quot;/quot;amp;TEXT(RIGHT(A1,LEN(A1)-SEARCH(quot;/quot;,A1)) 1,quot;000000quot;)
gt;gt;
gt;gt; HTH
gt;gt; --
gt;gt; AP
gt;gt;
gt;gt; quot;Melquot; gt; a écrit dans le message de news:
gt;gt; ...
gt;gt; gt;I have a two part number for tracking delivery notes, separated by a
gt;gt; gt;slash
gt;gt; gt; and each number increasing sequentially eg 8987/010942, 8988/010943
gt;gt; gt; etc.
gt;gt; gt; How
gt;gt; gt; can I do this automatically? Also Invoice Numbers eg ms/0988/06,
gt;gt; gt; ms/0989/06
gt;gt; gt; etc.
gt;gt; gt;
gt;gt; gt; Thanks.
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
Without using too complicated formulas:

Insert a column for the first part of the number ( e.g. column A) and a
column for the second part of your number ( e.g. Column B) and in the third
column use the formula =A1amp;quot;/quot;amp;B1

Sequential numbering can the be arranged in colums A and B

Hans

quot;Melquot; wrote:

gt; I have a two part number for tracking delivery notes, separated by a slash
gt; and each number increasing sequentially eg 8987/010942, 8988/010943 etc. How
gt; can I do this automatically? Also Invoice Numbers eg ms/0988/06, ms/0989/06
gt; etc.
gt;
gt; Thanks.
gt;
gt;

et voila! Thanks very much, now to understand the formula!

quot;Ardus Petusquot; wrote:

gt; Enter your initial value in A1:
gt; 8987/010942
gt; Enter my formula in A2:
gt; =LEFT(A1,SEARCH(quot;/quot;,A1)-1) 1amp;quot;/quot;amp;TEXT(RIGHT(A1,LEN(A1)-SEARCH(quot;/quot;,A1)) 1,quot;000000quot;)
gt; You should get the expected result of:
gt; 8988/010943
gt; You can now drag down my formula to get the following sequence numbers.
gt;
gt; If your initial value is no t in A1 but in any other cell, just replace A1
gt; with that other cell's address in my formula.
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Melquot; gt; a écrit dans le message de news:
gt; ...
gt; gt; Hi - sorry I failed! It returns #VALUE! Not sure what that means. I
gt; gt; should've maybe mentioned the numbers go down in a column? I'm a
gt; gt; relatively
gt; gt; new user so appreciate your help!
gt; gt;
gt; gt; quot;Ardus Petusquot; wrote:
gt; gt;
gt; gt;gt; Try this:
gt; gt;gt; =LEFT(A1,SEARCH(quot;/quot;,A1)-1) 1amp;quot;/quot;amp;TEXT(RIGHT(A1,LEN(A1)-SEARCH(quot;/quot;,A1)) 1,quot;000000quot;)
gt; gt;gt;
gt; gt;gt; HTH
gt; gt;gt; --
gt; gt;gt; AP
gt; gt;gt;
gt; gt;gt; quot;Melquot; gt; a écrit dans le message de news:
gt; gt;gt; ...
gt; gt;gt; gt;I have a two part number for tracking delivery notes, separated by a
gt; gt;gt; gt;slash
gt; gt;gt; gt; and each number increasing sequentially eg 8987/010942, 8988/010943
gt; gt;gt; gt; etc.
gt; gt;gt; gt; How
gt; gt;gt; gt; can I do this automatically? Also Invoice Numbers eg ms/0988/06,
gt; gt;gt; gt; ms/0989/06
gt; gt;gt; gt; etc.
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Thanks - but that doesn't seem to work, says there's an error in the formula?quot;hans bal(nl)quot; wrote:

gt; Without using too complicated formulas:
gt;
gt; Insert a column for the first part of the number ( e.g. column A) and a
gt; column for the second part of your number ( e.g. Column B) and in the third
gt; column use the formula =A1amp;quot;/quot;amp;B1
gt;
gt; Sequential numbering can the be arranged in colums A and B
gt;
gt; Hans
gt;
gt; quot;Melquot; wrote:
gt;
gt; gt; I have a two part number for tracking delivery notes, separated by a slash
gt; gt; and each number increasing sequentially eg 8987/010942, 8988/010943 etc. How
gt; gt; can I do this automatically? Also Invoice Numbers eg ms/0988/06, ms/0989/06
gt; gt; etc.
gt; gt;
gt; gt; Thanks.
gt; gt;
gt; gt;

=A1amp;quot;/quot;amp;B1 works in my Excel, but you can also try : =concatenate(A1;quot;/quot;;B1)
( ; is the list separator, depending on your regional settings you ay have
to replace it by a , )

quot;Melquot; wrote:

gt; Thanks - but that doesn't seem to work, says there's an error in the formula?
gt;
gt;
gt; quot;hans bal(nl)quot; wrote:
gt;
gt; gt; Without using too complicated formulas:
gt; gt;
gt; gt; Insert a column for the first part of the number ( e.g. column A) and a
gt; gt; column for the second part of your number ( e.g. Column B) and in the third
gt; gt; column use the formula =A1amp;quot;/quot;amp;B1
gt; gt;
gt; gt; Sequential numbering can the be arranged in colums A and B
gt; gt;
gt; gt; Hans
gt; gt;
gt; gt; quot;Melquot; wrote:
gt; gt;
gt; gt; gt; I have a two part number for tracking delivery notes, separated by a slash
gt; gt; gt; and each number increasing sequentially eg 8987/010942, 8988/010943 etc. How
gt; gt; gt; can I do this automatically? Also Invoice Numbers eg ms/0988/06, ms/0989/06
gt; gt; gt; etc.
gt; gt; gt;
gt; gt; gt; Thanks.
gt; gt; gt;
gt; gt; gt;

Hi - ok that worked (with the ,) but when I drag down it fills the cells with
the same number?

quot;hans bal(nl)quot; wrote:

gt; =A1amp;quot;/quot;amp;B1 works in my Excel, but you can also try : =concatenate(A1;quot;/quot;;B1)
gt; ( ; is the list separator, depending on your regional settings you ay have
gt; to replace it by a , )
gt;
gt;
gt;
gt;
gt; quot;Melquot; wrote:
gt;
gt; gt; Thanks - but that doesn't seem to work, says there's an error in the formula?
gt; gt;
gt; gt;
gt; gt; quot;hans bal(nl)quot; wrote:
gt; gt;
gt; gt; gt; Without using too complicated formulas:
gt; gt; gt;
gt; gt; gt; Insert a column for the first part of the number ( e.g. column A) and a
gt; gt; gt; column for the second part of your number ( e.g. Column B) and in the third
gt; gt; gt; column use the formula =A1amp;quot;/quot;amp;B1
gt; gt; gt;
gt; gt; gt; Sequential numbering can the be arranged in colums A and B
gt; gt; gt;
gt; gt; gt; Hans
gt; gt; gt;
gt; gt; gt; quot;Melquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a two part number for tracking delivery notes, separated by a slash
gt; gt; gt; gt; and each number increasing sequentially eg 8987/010942, 8988/010943 etc. How
gt; gt; gt; gt; can I do this automatically? Also Invoice Numbers eg ms/0988/06, ms/0989/06
gt; gt; gt; gt; etc.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks.
gt; gt; gt; gt;
gt; gt; gt; gt;

Set calculations to automatic: Tools/Options/Calculation

In article gt;,
Mel gt; wrote:

gt; Hi - ok that worked (with the ,) but when I drag down it fills the cells with
gt; the same number?