Hello! kindly help
Closed
dau
-
Dec 30, 2009 at 03:41 AM
dau234
dau234
- Posts
- 1
- Registration date
- Tuesday December 29, 2009
- Status
- Member
- Last seen
- December 30, 2009
Related:
- Hello! kindly help
- Whatsapp kinds - Guide
- Kinds of e - Guide
- Kinds of polymorphism - Articles
- Kinds of partition - Articles
- CPU KINDS HELP PLEASE ✓ - Forum - CPU/Desktop
2 replies
venkat1926
Dec 30, 2009 at 06:03 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Dec 30, 2009 at 06:03 AM
suppose the first sentry
is entered in A2 (row 1 is for headings)
IN a3 COPY THIS FORMULA
note the double quotes
this will become
copy A3 down
it will work till the number (001,002 etc till 999)-perhaps you require only upto 031
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
dau234
Dec 30, 2009 at 06:15 AM
- 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
REALLY APPRECIATE