Dallas-Fort Worth Real Estate Investor Club

Any Excel experts have time to help...?

  • 27 Apr 2020 9:06 AM
    Quote
    Message # 8930720
    Rich Jarvis

    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
    Quote
    Reply # 8932168 on 8930720
    Deleted user

    Maybe do text to Columns depending on how the data looks?  
  • 28 Apr 2020 8:04 AM
    Quote
    Reply # 8932855 on 8930720
    Rich Jarvis

    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
    Quote
    Reply # 8932885 on 8930720
    Terry Allen

    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
    Quote
    Reply # 8934302 on 8930720
    Rich Jarvis

    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
    Quote
    Reply # 8963488 on 8930720
    Austin Bright (Administrator)

    Did you solve the issue?
Powered by Wild Apricot Membership Software