Hi,
dear friends i have an text in a cell like abc room no.10/12 zxy 412365 sector-15 i need to get the value of 412365
ie want the number in that text which is have 6 digits.
thanks
Hi,
dear friends i have an text in a cell like abc room no.10/12 zxy 412365 sector-15 i need to get the value of 412365
ie want the number in that text which is have 6 digits.
thanks
Hello Liju144,
Do you require VBA or Excel Formula?
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
okay with both if formula then its more help and you can suggest in vba also
A B C 2abc room no.10/12 zxy 412365 sector-15 412365B2: =NumString(A2, 6)
This could probably be written to be faster:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
thanks the same is working which i required. can you help if am using formulas for this to find the same then how can i find it
Hi Liju144,
Thank you for the Feedback.
In the Column next to your Data containing, abc room no.10/12 zxy 412365 sector-15, and assuming your Data is in Cell B3, enter this Formula in Cell C3 and copy down as far as required.
You may also change the Cells or Ranges to suit.
Formula;
Formula:Please Login or Register to view this content.
Regards.
thankz for your help
Hi Liju144,
Please see attachment, for clear understanding.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks