I would like get the Name of each and without the text in bracket with formulation. Without using the hover over option on stock name to get the official name of stock. Spreadsheet is attached for reference.rnI'm using MS O365 on Windows.
Hello,
Unfortunately, no file attached.
Br,
Anders
Since you are using O365
Create your list of stock symbols.
Highlight and click on stocks
In an adjacent column, click on the little box that is adjacent to the first entry. Select "Name"
Sheet attached again. @Anders Sehlstedt
@ Alan Sidman - That's what I'm trying to avoid and want to understand if there's a way to get the result through a function.
Doing what Alan suggests created the functions in B2 and C2 (i.e. =A2.Name and =A2.[Official name], respectively).
A2 is a relative cell reference and works just like any other relative reference in Excel. And if A2 contains a value of the Stocks data type, the .Name and .[Official name] parts will be recognized automatically.
Now you can copy them down without the need to hover over every stock name in column A.
Absolutely, I get that and know it can work for entire list of stocks with a single click.
But, what I was wondering to get the name of stock with some of defined functions. Secondly, trying to understand what logic was put behind .Name and .Official Name. Although, this may not be in our scope however, would like to see what functions can be mixed to get the name of a stock.