Results 1 to 3 of 3

Thread: CONCATENATE usage

  1. #1

    CONCATENATE usage



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I have two question

    1) I have a huge column... and I want contents of each cell to be taken and put in one single cell .... how can I employ the "concatenate" function to select huge range ?

    2) How do I add some certain character to the end of each cell in range?
    For example is I have: text1, text2, text3 and I want to get text1A, text2A, text 3A and etc...

    Thanks

  2. #2
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    113
    Articles
    0
    Hi

    Post an example with a complete description
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

  3. #3
    Easiest way is to add a formula in an adjacent cell to take cell & concatenate, autofill down, copy /paste values on the new cells and delete the original column.

Posting Permissions

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