open office calc help

Discussion in 'BlackHat Lounge' started by Xellon, Nov 30, 2011.

  1. Xellon

    Xellon Regular Member

    Joined:
    Apr 22, 2011
    Messages:
    287
    Likes Received:
    51
    Occupation:
    Soldier
    Location:
    The future, year 2036
    Umm... I hardly use this program so I need some help. I'm trying to separate whats already in the columns by colon and then export it or copy/paste it into a text file. so yea...



    a - username b - nickname c - cheesename d - stupidname

    from this to

    username:Nickname:cheeseName:stupidname

    how do I do this?