Results 1 to 5 of 5

How can I find all rows w/ similar names then cut & paste them together?

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2011
    Location
    Houston, Tx
    MS-Off Ver
    Excel 2007
    Posts
    9

    How can I find all rows w/ similar names then cut & paste them together?

    Ok so lets say in Column A I have 100 names, and 10 of those names have Jo in the name, I click to highlight column a completely, I click control f to find, I type jo, click find all and all 10 pop up. They are the names I want to be able to cut and paste into column b. Is there a way I can do this and cut them all out together? I know I can click them one by one and cut/copy and paste them over but when the list is 100,000 and 10,000 with the name I am looking for, it just isn't efficient.

    I have excel 2007 if that helps.

    Someone help please! Thanks.
    Last edited by mrholmandirect; 07-10-2011 at 07:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1