I want to eliminate all the rows that have data begging with an alphabet.
For eg:
A1 - T12345
A2 - 123
A3 - 456
A4 - BH1
A5 - BHV
Result:
123
456
I want to eliminate all the rows that have data begging with an alphabet.
For eg:
A1 - T12345
A2 - 123
A3 - 456
A4 - BH1
A5 - BHV
Result:
123
456
A couple of questions
1/. Do You want to keep for example 123A?
2/. Are your numbers in number format or are they text?
Thanx for the quick reply
Data is in the text format, however, if u can share the resolution for both number format and text format,then it would be gr8 for me.
I woud like to keep rows that has numbers in it, no alphabets at all.
Hope this helps, awaiting response.
Try this (easier if your Data begins in A2)
In B2
=IF(ISNUMBER(A2*1),"","DELETE")
Drag/Fill Down
Filter on Column B = "DELETE"
Select the result and Delete > Rows
Remove the filter
Hope this helps
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
It' showing Delete against all cells. Please advise. if it has something to do with the data format.
Able to rectify the glitch, values in cell have a space on the right.
If you haven't resolved this, can you post a sample workbook?
Its working mate, what if I want to exclude a particular alphabet, I want all the numeric data and the one beginning wid "Q"
Same steps again, but use
In B2
=IF(OR(ISNUMBER(A2*1),LEFT(A2,1)="Q"),"","DELETE")
Hope this helps
Super genius.
Happy to have been of some help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks