Previous Topic Next Topic

Hello! kindly help

Closed
dau - Dec 30, 2009 at 03:41 AM
dau234
Posts
1
Registration date
Tuesday December 29, 2009
Status
Member
Last seen
December 30, 2009
 - Dec 30, 2009 at 06:15 AM
Hello,
can someone kindly help:
am tryin to make a cell e.g displaying ELD/001/12/09
the lower cell immediately after it to display ELD/002/12/09

:) thanks all and waiting to hear from you
Related:

2 replies

Answer 1 / 2
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 805
Dec 30, 2009 at 06:03 AM
suppose the first sentry 
ELD/001/12/09

is entered in A2 (row 1 is for headings)
IN a3 COPY THIS FORMULA 
="ELD/"&TEXT(MID(A2,5,3)+1,"000")&"/12/09"

note the double quotes
this will become 
ELD/002/12/09


copy A3 down

it will work till the number (001,002 etc till 999)-perhaps you require only upto 031
0
Answer 2 / 2
dau234
Posts
1
Registration date
Tuesday December 29, 2009
Status
Member
Last seen
December 30, 2009
Dec 30, 2009 at 06:15 AM
THANKS! IT WORKS!
REALLY APPRECIATE
0