Searching specific word with find function

Dear Sir,
I have the sample data to contain with unit as TEU and M3. I tried to find these units to be new column to show as TEU or M3.
I saw in raw data to show these unit but when I used the find function.It can not active. Moreover, when I click into each cell.I cannot see the unit to show but I saw without click into the cell. There are something wrong in this raw data? I use the real data and just revised the number.
Please kindly suggest for this case.
thanks a lot.

The "TEU" / "M3" are result of the format and do not appear in the cell itself.

Click on cell in A, then "Format cells" and you will see the format.

Hi Sir,
Right Click -- format cell -- and then? I try to change format cell to be text?
sorry , please clarify more ? still not understand how to solve this solution.

thanks a lot.

Please Login or Register  to view this content.

The above UDF returns the currency tags

See attached

Hi sir
Thank a lot but i want to show only TEU or M3 as in the formular.
It will work right?
And in case i have to use your vb in my original girl?how i van do?
Pls suggest.
Thanks.

Hi John
How can insert this code in original excel file?
Please suggest.
thanks.

Click on "Developer"==>"Visual Basic"

Right Click "Thisworkbook" ==> Insert==> Module

Copy/paste code on blank page

Hi John
as i ask previous that I need to show only "TEU" or "M3" as my excel formular. pls suggest.
thanks a lot.

Hi, John
I tried with attached photo
and close right?
but the formula still not work.

Please post a file with "problem". You need to put

=GetCurrency(A2) in B2 if the data is A2: this will display the currency data

It only returns "M" not "M3": I obtained the code from the Wen and I don't know how to change it to show the numeric digit.

Hi, John
I attached the revised excel file to you with insert visual basic code but still not show right results.
I change the raw data to be new set as show only number and unit , no currency. I think the visual basic code is apply for old raw data with currency right.
Please suggest.
thanks a lot.

Or try:

Please Login or Register  to view this content.

I use this code to insert in visual basic as this workbook right?
and use getcurrency in excel file but show that #NAME?

Hi
still not work.

Hi,
I use this formular withing formular sheets mean that I use index match to pull all raw data to new sheet and then I use put getcurrency2(cell) in same sheet which contain all formular with all index match but i try to use getcurrency2(cell) from raw data and run.
so it can not use formula within formula?
i ever tried to vlookup with index colum which contain formula and can work.
so confuse. haha
pls suggest.
thanks a lot for all helps.

Please post a file with the "error" condition.

Hi Sir,
Could you please help for this post?

https://www.excelforum.com/excel-pro...condition.html

thanks.