Ok,
I have data with 8000+ rows.
The data is combined in on column for each row(entry).
It contains Last name, first name, dates, account#, dollar amount, etc.
every thing is just inside one column separated by a sapce
Now i want to delete specific entries within each row, there are the three or four digit random numbers coming in every row (like 932 799 125 2514 1450 etc).
If i make the data "text to column" these random numbers are not sorted under one column. Some of these number come under column B, C, D, E depending on the other missing fields in the rows.
Can I run a formula to delete (3 digits) (4 digits) from every row. so that where it finds a number in row with three digits it simply delete it so that i can get rid of these random number from the rows.
I cant do it manually because there are 8000+ entries.
Someone please suggest me a formula to run accordingly for deleting 3digit number from a row, so that I can apply to all rows.
Hope you understand what I am saying.
Thanks,
Bookmarks