Results 1 to 4 of 4

Concatenate function to join some text strings

Threaded View

FRJ1949(Frank) Concatenate function to join... 01-11-2010, 03:02 PM
NBVC re: Concatenate function to... 01-11-2010, 03:10 PM
FRJ1949(Frank) re: Concatenate function to... 01-11-2010, 03:20 PM
NBVC re: Concatenate function to... 01-11-2010, 03:30 PM
  1. #1
    Registered User
    Join Date
    01-11-2010
    Location
    Carlisle UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Concatenate function to join some text strings

    I have been trying to use the concatenate function to join some text strings to a cell on a different sheet - From an input sheet -Sheet 1 named Input, to a Notification Form (Sheet 2). Although the Function Argument display tells me that it will display the result I want it actually displays just the formula. It's a very simple thing

    Address 1 10 Downing Street
    Address 2 Westminster
    Address 3 London
    Postcode SW1A 1AA

    I want displayed as: 10 Downing Street, Westminster, London, SW1A 1AA in a single merged cell.

    All I am getting on the Form is =concatenate(Input!c25," ",Input!c26," "Input!c27," "Input!c28)

    I feel sure that it is a very easy solution but I can't arrive at it!!


    Any ideas for me please Frank
    Last edited by FRJ1949(Frank); 01-11-2010 at 03:47 PM.

Thread Information

Users Browsing this Thread

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

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