Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Join two columns (2003)

    Hi all,

    I have two questions: Q1. On an excel sheet I have 3 columns, Surname, Name, NINO, how can I make columns surname and columns first name as one filed for instance full name and be displayed Surname, First name. and questions 2. I have another sheet which has only on address column, how can I move it two 4-5 different columns i.e.g address 1, address 2 address3 etc.

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Join two columns (2003)

    1> You can use a formula such as =A1&", "&B1 to concatenate the surname in A1 and the first name in B1. Such a formula can be filled down.

    2> If the addressed are separated by a comma or similar, you can select the column with addresses, then select Data | Text to Columns.
    Specify Delimited, then click Next.
    Specify Comma as delimiter, then click Finish.
    You will probably have to perform some manual cleaning up.

    Make a backup copy before trying this, so that you can go back if you mess it up!

  3. #3
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Join two columns (2003)

    Many thanks HAnsV that is what I needed.

Posting Permissions

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