1. Calculation functions
2. All Functions
3. Text Functions
4. NAME

Use the NAME function to convert data from a list item to text.

NAME(list_item)

## Argument

 Argument Data type Description list_item List item The list item you want to convert to text.

This returns a text string.

## Syntax example

NAME (Month period)
This returns the month period as a text string where month period is the line item and the result is the name of the month.

## Constraints

The function has no constraints.

T

## Examples

### Use NAME with Time

This example shows how you can use the NAME function to return a text formatted line item from the Time list.

The module is displaying the months for 2020.

The NAME calculation function is applied to the line item Month Period formatted as Time>Month and returns the Period Name Month as a line item formatted as text:

 Formula Description Result NAME(Month Period) The module, Accounts Period, displays the Key Dates and Expiry Dates for a company's accounts. The line items are: Key Dates Expiry Dates The line items and their formats are: Period Name Month (text format) Month Period (time format; Month) where the month periods are editable cells. The formula NAME(Month Period) identifies the Month for the Month Period the line item. It then converts the data type from a list item formatted line item to a text. The result displays in the Key Dates and Expiry Dates columns for the Period Name Month line item.

#### Source model

Period Name Month: NAME(Month Period)

Accounts period

 Key Dates Expiry Dates Period Name Month Feb 20 Apr 20 Month Period Feb 20 Apr 20

### Use NAME with another function

You can use NAME with another function. This example shows how you can use NAME to return the name of a product in text format.

 Formula Description Result NAME(ITEM(Products)) In this example, a company is looking at the Product Margins for their clothing products.  The module is called Product Margins. The list is called Products and its list items are the different types of clothing the company produces. These are: T-shirts Coats Sweaters Trousers Shorts The line items are: Annual Purchase Annual Sales Product Season Annual Margin Product Name The list items for Products are the columns and the line items are the rows. The function, NAME references the line item, Product Name. The formula is:  NAME(ITEM(Products)) The formula uses two functions; ITEM and NAME. The ITEM function picks up the list item and then the NAME function is applied to convert that list item to text. It returns the text equivalent of the list item.  In summary, the NAME function specifies the name of the product as text.

#### Source model

Product Name: NAME(ITEM(Products))

Product Margins

 T-shirts Dresses Sweaters Trousers Shorts Annual Purchase 328,765 238,976 348,432 349,876 467,831 Annual Sales 404,876 289,743 401,239 378,765 502,349 Product Season Summer Summer Fall Fall Summer Rank clothing with same season 4 6 4 6 3 Annual Margin 76,111 50,767 52,807 28,889 34,518 Product Name T-shirts Dresses Sweaters Trousers Shorts

The Product Name items are text.