Formula Issue
Results 1 to 5 of 5

Thread: Formula Issue
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2012
    Location
    Alabama
    Posts
    740
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula Issue

    I have the following formula im having a little trouble with.

    =(C12&" "&D12&"x "&E12&" "&F12)

    C12 is formatted as Fractional and D12 is formatted as Short Date. They are showing up as numbers in a decimal. Is there a way to have the format called out for each cell in the formula.

  2. #2
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,679
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Formula Issue

    Something like:

    =TEXT(C12,"# ?/?")&" "&TEXT(D12,"dd/mm/yyyy")&"x "&E12&" "&F12

    Adjust formats to suit.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  3. #3
    Board Regular
    Join Date
    Jan 2012
    Location
    Alabama
    Posts
    740
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula Issue

    Thanks for the help. One more question. If there is no data in some of these cells how can I get those not to show up?

  4. #4
    Board Regular
    Join Date
    Sep 2018
    Location
    New Delhi, India
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula Issue

    Trim function is best suited to your need - It automatically eliminates Blank entries and extra spaces. Hope it helps

    Quote Originally Posted by bamaisgreat View Post
    If there is no data in some of these cells how can I get those not to show up?

  5. #5
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,679
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Formula Issue

    Try:

    =IF(LEN(C12),TEXT(C12,"# ?/?")&" ","")&IF(LEN(D12),TEXT(D12,"dd/mm/yyyy")&"x ","")&E12&" "&F12
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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