Hello, I'm having a issue that might be super simple for some of you but I think I'm over thinking it. But I need the data in columns "J" "K" "L" "M" with out a alpha or any number small then 7 digits. It could be as high as 9 digits. The same goes for columns "O" "P" "Q" "R". The finished results need to be like in columns "A" "B" "C" "D".
I hope I have given enough information.
Thanks
Mark
Any advice on this?
It looks like everything should be deleted since column M is only alpha. This does not jive with your after, since D is allowed to have alpha.But I need the data in columns "J" "K" "L" "M" with out a alpha or any number small then 7 digits
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Sorry, I should have said that J and O are the ones that I can use alpha in. Basically I need to combine the (J" "K" "L" "M") ("O" "P" "Q" "R) into "A" "B" "C" "D" with the alpha ones in J and O. I need all the U#### and the four digit numbers removed from the completed combined columns.
A-B-C-D is the completed finished product. I want a simple way to combine them without copying and paste to create it. I don't need all the U#### and the four digit numbers removed from the completed combined columns.
I hope this helps,
Mark
Unfortunately, without going into VBA (which is not a simple way) the easiest path is to copy/paste/sort/filter.
I would cut/paste the OPQR block to the end of the JKLM block. Then I would create a helper column (likely N) with a function like this:
=AND(ISNUMBER(J3),LEN(J3)>6)
(drag this formula down to the end of the list).
I would then sort the JKLMN block with column N and then delete all of the rows where N is FALSE
I think you're right I need to use VBA. Any advice on how to do that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks