+ Reply to Thread
Results 1 to 7 of 7

joining columns

  1. #1
    Registered User
    Join Date
    05-26-2014
    Posts
    4

    joining columns

    I know i sound very NEW to this but I'm not really, just self taught and don't know much!! How can I combine a text column with a number column - i.e. index= text; page no. = number. I need both in one column.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: joining columns

    use concatenate
    concatenate(A1,B1)
    OR
    A1&B1

    & is the same as concatenate
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    05-26-2014
    Posts
    4

    Re: joining columns

    You are a star Wayne
    Thank... so simple, I feel like a real novice.

  4. #4
    Registered User
    Join Date
    05-26-2014
    Posts
    4

    Re: joining columns

    Wayne - it works - but is there any way you can keep the formatting in the cells (i.e. if I have a word in italics, how do I keep that in italics/bold etc.)?

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: joining columns

    your welcome, thanks for the rep

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: joining columns

    you maybe able to use something like

    the TEXT() function changes the format of the cell
    =TEXT(A1,"#,##0.00") & TEXT(B1,"dd mmm yyyy")

    but i dont know how to make it do italics

    maybe conditional formatting may help

    can you perhaps attach a short sample spreadsheet

    I'm off line now for a while , i'm afraid - UK timescales

  7. #7
    Registered User
    Join Date
    05-26-2014
    Posts
    4

    Re: joining columns

    WIll give it a bash and let you go to sleep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Joining Columns one below the other
    By harshj in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-16-2013, 06:57 PM
  2. Excel 2007 : joining multiple columns
    By samw1982 in forum Excel General
    Replies: 1
    Last Post: 04-21-2009, 09:12 PM
  3. Joining lists from 3 columns
    By simonhall in forum Excel General
    Replies: 5
    Last Post: 10-28-2007, 11:12 PM
  4. joining two columns together
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2006, 11:25 AM
  5. Joining Two Columns
    By Kartal in forum Excel General
    Replies: 4
    Last Post: 05-03-2006, 06:10 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1