+ Reply to Thread
Results 1 to 3 of 3

Combining dates & text and transferring to separate sheet

  1. #1
    Registered User
    Join Date
    11-22-2010
    Location
    Salt Lake City, UT
    MS-Off Ver
    Professional Plus 2013
    Posts
    54

    Combining dates & text and transferring to separate sheet

    I want to combine a date and text from one sheet and plug that into a master sheet. I've tried this in the cell I want to use in the master sheet and it keeps saying there is an error:

    =OneSheet!((TEXT(A2,"mm/dd/yyyy")&" "&B2))

    What am I doing wrong?

    Thanks!

  2. #2
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Re: Combining dates & text and transferring to separate sheet

    Perhaps:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

  3. #3
    Registered User
    Join Date
    11-22-2010
    Location
    Salt Lake City, UT
    MS-Off Ver
    Professional Plus 2013
    Posts
    54

    Re: Combining dates & text and transferring to separate sheet

    Thank you!!

+ 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. Transferring expiry dates automatically to another sheet
    By davehow87 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-15-2015, 01:45 AM
  2. Replies: 1
    Last Post: 07-25-2013, 05:09 PM
  3. Help Transferring Data from one sheet to Another Based on Dates
    By da1nonlybige in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2013, 11:04 AM
  4. Combining text from separate userform fields
    By nohero in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2011, 10:36 AM
  5. Transferring a value assigned to a name in a separate sheet
    By bobbby1949 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 10-01-2010, 06:15 PM
  6. Transferring from one ''Annual'' sheet to separate ''Monthly'' sheet and reverse
    By crehan57 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2010, 09:39 AM
  7. Transferring text from separate spreadsheet
    By murrayss in forum Excel General
    Replies: 1
    Last Post: 02-12-2008, 03:21 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