DFW REI Club

 Dallas/Fort Worth Real Estate Investor Club

Any Excel experts have time to help...?

  • 27 Apr 2020 9:06 AM
    Message # 8930720

    I have a report I pulled with data, contacts I need to format into first name, last name, for skip tracing. But the data comes in the format of last name first name (same cell/column) and additional first name (next cell/column)...


    is there a smart way to format this information into first name/s last names, adjoining columns...?


    Thank you!!!

  • 27 Apr 2020 9:04 PM
    Reply # 8932168 on 8930720

    Maybe do text to Columns depending on how the data looks?  

  • 28 Apr 2020 8:04 AM
    Reply # 8932855 on 8930720

    Thank you Brian,

    I tried that and it seems to work best, However when it overwrites some data in a couple of adjoining columns...stuff I would like to keep.



  • 28 Apr 2020 8:35 AM
    Reply # 8932885 on 8930720

    Rich,

    Before you perform the Text-To-Columns conversion, insert a few blank columns immediately to the right of the data column. For example, if your data column has First Name, Last Name, insert two blank columns to the right of the data column. That should make cells available to put the results without overwriting other information.

    Terry


  • 28 Apr 2020 7:17 PM
    Reply # 8934302 on 8930720

    Thank you Terry,

     i tried inserting 1 blank column but when that didn't work I stopped there. I will follow your lead.


    Thanks!

  • 12 May 2020 10:05 AM
    Reply # 8963488 on 8930720

    Did you solve the issue?


Contact Us  |  Advertise With Us

Copyright © 2008-2020, Nubys Group, LLC

Powered by Wild Apricot Membership Software