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

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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
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