I took a short virtual walk from the Etihad in Google Earth and the exported KML file was over 1,000 lines (for a 1/2hr walk) so presumably not a viable solution for you.
However, you mention cell A1 rather than, for example, ColumnA, so a manual process might be acceptable, provided not subject to error from keying coordinates with lots of decimal places.
So, if you paste the link (click on Share) to Etihad Stadium from Google Maps into A1:
and then delete all up to and including
!4d what you should be left with is:
which when searched in Google Maps shows a pin just on the circumference of the centre circle, or in Google Earth: