Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Concatenate Columns

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have some customers that email spreadsheets of three and four columns that I need all the information in one column.

    Such as:

    Column 1; Column 2; Column 3
    Last name, First name; Social Security #; Date

    I need this information to appear as one column as follows:

    Last name, First name; Social Security; Date

    This will then be cut and pasted in to an access database.

    Thank you,
    Jennie

    Jennifer J. Weislak
    XEROX Business Services
    jweislak@xbs-toledo.com
    419-248-7336


    [ This Message was edited by: jweislak@xbs-toledo.com on 2002-05-10 07:40 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,033
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-10 07:39, jweislak@xbs-toledo.com wrote:
    I have some customers that email spreadsheets of three and four columns that I need all the information in one column.

    Such as:

    Column 1 Column 2 Column 3
    Last name, First name Social Security # Date

    I need this information to appear as one column as follows:

    Last name, First name; Social Security; Date

    This will then be cut and pasted in to an access database.

    Thank you,
    Jennie

    Jennifer J. Weislak
    XEROX Business Services
    jweislak@xbs-toledo.com
    419-248-7336
    Last name, First name; Social Security; Date

    =A1&", "&B1&"; "&C1&"; "&D1

    Give a double click on the fill handle of the formula cell.

    Just curious: Why would you reduce all this into a compound field in a database?

    Aladin

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Alan,

    The company that I work for wants it that way I prefer it separated they do not.

    Thank you for your help I will try this I was having trouble with the number factors.

    Jennie

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,033
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-10 07:50, jweislak@xbs-toledo.com wrote:
    Alan,

    The company that I work for wants it that way I prefer it separated they do not.

    Thank you for your help I will try this I was having trouble with the number factors.

    Jennie
    You mean the date thing I guess. Darn it. Make that concat formula:

    =A1&", "&B1&"; "&C1&"; "&TEXT(D1,"mm/dd/yy")

    Adjust to suit the last part.

    Cheers.

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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