+ Reply to Thread
Results 1 to 2 of 2

Alternatives to concat

  1. #1
    Registered User
    Join Date
    09-09-2021
    Location
    Madrid
    MS-Off Ver
    16.52
    Posts
    8

    Alternatives to concat

    Hi,

    Screen Shot 2021-10-05 at 2.59.34 PM.png

    This should be easier than using concat

    Screen Shot 2021-10-05 at 3.02.15 PM.png

    =CONCAT(X2,":",Y2,":","1",",",Z2,":",AA2, ":", "2",",",AB2,":",AC2,":", "3",",", AD2,":",AE2,":","4",",",AF2,":",AG2,":","5",",",AH2,":",AI2,":","6",AJ2,":",AK2,":","7",",",AL2,":",AM2,":","8",",",AN2,":",AO2,":",9,",",AP2,":",AQ2,":", "10",",",AR2,":",AS2,":","11",",",AT2,":",AU2,":","12",",",AV2,":",AW2,":","13",",",AX2,":",AY2,":", "14",",","Garantía",":","5 años",":","15")

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,792

    Re: Alternatives to concat

    16.52 means nothing to me - which version of Excel do you have? Is it a Mac version?

    Your title is poor and you do not say anywhere what you are trying to do - do you expect your helpers to be able to work this out???

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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] extract last 3 numbers from each concat. value in col. B and add to col. A concat cells
    By therealdees in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-17-2021, 11:02 AM
  2. CONCAT vs CONCATENATE
    By ionelz in forum Excel General
    Replies: 6
    Last Post: 03-01-2019, 05:25 AM
  3. [SOLVED] =CONCAT questions
    By GigG in forum Excel General
    Replies: 6
    Last Post: 10-22-2018, 05:10 PM
  4. Concat help
    By fluters1243 in forum Excel General
    Replies: 10
    Last Post: 06-30-2017, 11:14 AM
  5. [SOLVED] Concat help
    By anuraag205 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-02-2013, 02:13 AM
  6. concat function
    By okl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2008, 10:00 AM
  7. [SOLVED] Concat Macro help...
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 08-08-2006, 12:15 PM

Tags for this Thread

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