Extract Text and Numbers from Custom Type Cell

Hello all,

I need some help with extracting exactly the same text as it is shown on Custom type cell (Number with "Text") in Excel.

The problem is in case I convert the Custom type cell to General or Text type cell it returns only a number, but not text.

I have been wondering if there is a function in Excel in order to extract "ASSET_20__UP" into General type cell?

Any help will be appreciated.

Untitled.jpg