+ Reply to Thread
Results 1 to 2 of 2

Adding / to concatenate a cell

  1. #1
    Registered User
    Join Date
    03-02-2021
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    1

    Exclamation Adding / to concatenate a cell

    Hi All

    As an example:

    Unit # St # Combined
    1 123 1234 John Street

    In column Unit # I need to add a / in every cell. This then has a concatenate formula to make the combined look like 1/234 John Street, however when I change the number format to add a / it will not concatenate.

    If you add a / manually to each cell it will.

    Any ideas?

    Thanks
    Tammy

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Adding / to concatenate a cell

    You can concatenate Text strings using &.

    So if Cell A2 has 1 & B2 has 234 John Street, In cell C2, the formula will be = a2 & "/" & b2
    Cheers!
    Deep Dave

+ 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] Adding Parentheses to a Concatenate Formula??
    By Pooger in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-01-2021, 11:17 PM
  2. [SOLVED] Stop concatenate adding decimal places back
    By ethanJCB in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-13-2017, 09:24 AM
  3. Adding values to concatenate function by clicking buttons
    By pomper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2017, 02:29 PM
  4. Adding 2 decimals regardless of sig figs to CONCATENATE formula
    By ExcelSponge in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-01-2016, 02:38 PM
  5. Concatenate with Double Info in Concatenate Cell
    By MRoz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2015, 02:07 PM
  6. Adding complicated CONCATENATE formula to range in column
    By HughManatee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2014, 06:48 PM
  7. Adding a count to concatenate range function
    By mbus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-12-2013, 11:18 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