+ Reply to Thread
Results 1 to 4 of 4

Formula to combine two cells contents into a new one separated with a "/" for the new cell

  1. 05-14-2020, 10:32 AM #1
    MGadAllah
    MGadAllah is offline
    Forum Contributor MGadAllah's Avatar
    Join Date
    04-13-2008
    Location
    Sheet1
    MS-Off Ver
    365,2307,16.0.16626.20170,64bit
    Posts
    190

    Formula to combine two cells contents into a new one separated with a "/" for the new cell

    Hi,
    I've two cells.
    1st one A1 has the content 2016
    2nd one A2 has the content 2017
    I want to add a formula into A3 to make the result 2016/2017
    Also I want to make sure that it will be right in A3 in case I changed the content in A1 and A2 later on.
    Thanks
    Reply With QuoteRegister To Reply
  2. 05-14-2020, 10:35 AM #2
    MRUTOR
    MRUTOR is offline
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Formula to combine two cells contents into a new one separated with a "/" for the new

    Hi,

    in A3: =A1&"/"&A2
    Greetings

    Tor

    Reply With QuoteRegister To Reply
  3. 05-14-2020, 11:35 AM #3
    MGadAllah
    MGadAllah is offline
    Forum Contributor MGadAllah's Avatar
    Join Date
    04-13-2008
    Location
    Sheet1
    MS-Off Ver
    365,2307,16.0.16626.20170,64bit
    Posts
    190

    Re: Formula to combine two cells contents into a new one separated with a "/" for the new

    Thanks
    Last edited by AliGW; 05-14-2020 at 11:44 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 05-14-2020, 11:44 AM #4
    AliGW
    AliGW is online now
    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. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,782

    Re: Formula to combine two cells contents into a new one separated with a "/" for the new

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Updates Pivot Table by cell contents, i want to show "blank" instead of "all"
    By mattinwpg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2017, 10:58 PM
  2. What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:M39"
    By woshichuanqilz in forum Excel General
    Replies: 4
    Last Post: 06-11-2017, 02:03 PM
  3. [SOLVED] formula for "if a cell contain text" wen looking for 2 separated strings
    By Tamar81 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-11-2013, 01:59 AM
  4. [SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2013, 05:36 PM
  5. [SOLVED] Combine "=IF" and "=HOUR" statement for cell formula
    By chriswhite1982 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2013, 02:42 PM
  6. "Form and macro" to delete "Active" cell contents.
    By wanty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2013, 11:33 PM
  7. Combine "Total" and cell contents
    By cottage6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2005, 01:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1