archilles89
New Member
- Joined
- Jun 3, 2018
- Messages
- 5
Hi,
I have a jumble of text string where in one column I have to extract the text only (no numbers and special characters) while on the other column I have to extract numbers only (no text and special characters)
<tbody>
</tbody>
Can someone help me derive a formula for this?
Currently I am using this
Any help would be awesome thank you!
I have a jumble of text string where in one column I have to extract the text only (no numbers and special characters) while on the other column I have to extract numbers only (no text and special characters)
String | Text | Number |
aaabbb!.,'1234222 | aaabbb | 1234222 |
abc@gmail.com | abcgmailcom | |
*82.\3246"5656) | 8232465656 |
<tbody>
</tbody>
Can someone help me derive a formula for this?
Currently I am using this
and manually CTRL+F them and replace them all. Kinda hard.=IF(OR(LEN(A2)>40,ISTEXT(FIND({"1","2","3","4","5","6","7","8","9","0","!","@","'","""","]","[","}","{","|","&","$","#","^","~","%","®","-",""},A2))),"Bad","Good")
Any help would be awesome thank you!