Hyperlink edit
Closed
sibalamit
-
Sep 14, 2009 at 11:27 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 15, 2009 at 06:26 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 15, 2009 at 06:26 AM
Related:
- Hyperlink edit
- Edit time in whatsapp - Guide
- Remove hyperlink in word - Guide
- How to edit an image in google docs - Guide
- How to edit best friends on snap - Guide
- Hyperlink in gmail - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 15, 2009 at 06:26 AM
Sep 15, 2009 at 06:26 AM
quote
http://www.nseindia.com/content/historical/EQUITIES/2009/SEP/cm14SEP2009bhav.csv
unquote
suppose A1 has date 9/14/09-try this formula
in an empty cell copy paste this formula. In some versions there will be a mess up
so in an empty cell first type single quote(')and then copy paste this formula with not space between single quote and this text
and then highlight this cell delete the leading single quote and ENTER.
="http://www.nseindia.com/content/historical/EQUITIES/"&YEAR(A1)&"/"&TEXT(A1,"mmm")&"/cm"&TEXT(A1,"ddmmmyyyy")&"bhav.csv"
when you change A1 automatically this formula also will change
http://www.nseindia.com/content/historical/EQUITIES/2009/SEP/cm14SEP2009bhav.csv
unquote
suppose A1 has date 9/14/09-try this formula
in an empty cell copy paste this formula. In some versions there will be a mess up
so in an empty cell first type single quote(')and then copy paste this formula with not space between single quote and this text
and then highlight this cell delete the leading single quote and ENTER.
="http://www.nseindia.com/content/historical/EQUITIES/"&YEAR(A1)&"/"&TEXT(A1,"mmm")&"/cm"&TEXT(A1,"ddmmmyyyy")&"bhav.csv"
when you change A1 automatically this formula also will change