LinkBack URL
About LinkBacks
Dear's
I need to extract numbers from text/ sentances, can i have a standard formulas for that ?
rGRDS.
Extract numbers from Text
Dear's
I need to extract numbers from text/ sentances, can i have a standard formulas for that ?
rGRDS.
It all depends on your data. Take a look at this thread:
http://www.excelforum.com/excel-gene...t-columns.html
for one approach, then attach a sample workbook showing examples of your data and what you want to do with it.
Hope this helps.
Pete
this is the sample sheet
Try this...
=REPLACE(A2,1,FIND(".",A2),"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
but its faile to extarct the numbers for the sentense which was number & text together , or without any ".".
This is why it is important to provide accurate requirements and samples that represent various combinations. We just can't read your mind
You can also try this one. It will work as long as the numbers on the end are always 7 characters long.
=RIGHT(A2,7)
You need to provide examples that cover the range of variations in your data - in the file that you attached all the examples have a full-stop immediately before the number. If you have data that is not like that then provide examples of it.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks