converting numbers into text

[lezawang]

Hi
I am reading the article below and although he gave an example why converting number to text is needed, I did not understand the example. Can you please give me examples/reasons why that is needed? Thank you


https://exceljet.net/formula/convert-numbers-to-text

 

[mole999]

the example mentions wild cards so searching for numbers beginning and ending in 5 would find 505 515 525 to 595 with "5*5" otherwise that would be 25 5 times 5

 

[Dolphinv4]

One example that I often use is on date values.

ie, if I want to change 15/4/18 (in A1) to 1804 (ignoring day), then I'll use =TEXT(A1,"YYMM").

Or if you only want the month, then =TEXT(A1,"mmmm") then you'll get April.

 

[MARK858]

Similar to what mole999 has posted but I would normally concatenate the wild cards to allow the use of cells to hold the number rather than hard coding the search number in the text string i.e. as per C2 & C3 below.

In the formulas in C1:C3 the $A$1:$A$4&"" is converting the array of numbers to text, if you don't (or convert the actual numbers to text) then you get the result in H1.
I1 is just there to demonstrate what mole999 has stated (select the cell then formula tab - Evaluate formula - click Evaluate and see the result in the formula. click Evaluate again to see what the 25 is matching against)

Clearer on what the article is saying?

Excel 2010
	A	B	C	D	E	F	G	H	I
1	507		3		5	2		#N/A	#N/A
2	517		3
3	565		4
4	295
Sheet3

Cell Formulas
Range	Formula
H1	{=MATCH(5&"*"&5,$A$1:$A$4,0)}
I1	{=MATCH(5*5,$A$1:$A$4&"",0)}
C1	{=MATCH(5&"*"&5,$A$1:$A$4&"",0)}
C2	{=MATCH(E1&"*"&E1,$A$1:$A$4&"",0)}
C3	{=MATCH(F1&"*"&E1,$A$1:$A$4&"",0)}
Press CTRL+SHIFT+ENTER to enter array formulas.