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
- Hyperlink in gmail - Guide
- Remove hyperlink in word - Guide
- Lg tv edit input names - Guide
- Can you edit your best friends list with snapchat plus - Guide
- Lg tv edit home screen - 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
