Hi All,

I'm a newbie in this forum I need help with my project in which I have to deal with various type of data.

So, I have big data in excel that require me to sort out the cell that contain "TEXT" only value. Below I enlist some dummy data which pretty similar with the one I have to deal with.


A | B |
0303-numbers
0303numbers
0313so
031v13807x
0330-numbers
0333-numbers
BOOKISGOOD
careers-seminar
newyork
holland-newyork
123456



From the above data, I need to get the cell that contain TEXT only (no dashes, no numbers) which are: "BOOKISGOOD" and "NEWYORK". So maybe for this cell I want a remark "X" in column B.

As for the cell that contain "dashes"/ (-) with "Y" remark in column B, and NUMBERS only cell with "Z" remark, and cell with combination of TEXTS and NUMBERS with "O" remark.

I really appreciate if anyone could help me to share some insights how to accomplish this project.

Thanks in advance