Hello! kindly help

[Closed]
Report
-
Posts
1
Registration date
Tuesday December 29, 2009
Status
Member
Last seen
December 30, 2009
-
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

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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
Posts
1
Registration date
Tuesday December 29, 2009
Status
Member
Last seen
December 30, 2009

THANKS! IT WORKS!
REALLY APPRECIATE