I have some data as mentioned below. 2150.1522 2159.1526 2178.1534 2234.1567.122220 2256.1528.1309990 I need only the nunbers start with 15 to be copied in another column is there any formula? Pls reply.
There are many ways to do this. If you have 1234567890 in the cell A1, use the following formula for the required output. =TEXT(A1,"#####-#####") Another formula to create the same result =LEFT(A1,5)&"-"&RIGHT(A1,5) Please refer to my video on TEXT function for more details.
ഇരുന്നൂറിലധികം Excel Tip Videos.
ua-cam.com/play/PLWQHdO5npdTIwkK2CZN-S_a_2u-eLD_89.html
Good one Ajay 👌🏻
Thank you
Thanks
Ee paranja valya formula koodi onn explain cheyyaarnn...... 😌
I have some data as mentioned below.
2150.1522
2159.1526
2178.1534
2234.1567.122220
2256.1528.1309990
I need only the nunbers start with 15 to be copied in another column is there any formula?
Pls reply.
Sir,
Oru ten number sereisinte middlil oru hyphon(-) idunnathinulla equation onnu paranju tharaamo
Eg::12345-67890 like this
There are many ways to do this.
If you have 1234567890 in the cell A1, use the following formula for the required output.
=TEXT(A1,"#####-#####")
Another formula to create the same result
=LEFT(A1,5)&"-"&RIGHT(A1,5)
Please refer to my video on TEXT function for more details.