I have a long list over 1 millions rows. I have one column that have either a number that beginns with a 9 or 14 and I want to pull all the numbers that begin with 9 and copy them from cell B1 to C1 and if is a 14 leave that number on column B.
Thank you Ron Anny
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.