+ Reply to Thread
Results 1 to 4 of 4

Adding Text to A Box With a Formula

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    seattle
    MS-Off Ver
    Open Office
    Posts
    24

    Adding Text to A Box With a Formula

    I have a couple of formulas that I want to put in a box with the word "to" in between the results, so it looks like this"

    -10 to 10

    the formulas are = a1-b1 and = a1 + b1 ...

    this is pretty basic I know...

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Adding Text to A Box With a Formula

    May be this......

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    03-11-2014
    Location
    seattle
    MS-Off Ver
    Open Office
    Posts
    24

    Re: Adding Text to A Box With a Formula

    that pretty much got me there. I just have to work out how to format the numbers now.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Adding Text to A Box With a Formula

    Glad to help you. Thanks for the feedback.
    If that takes care of your question, please mark your thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

+ 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. Adding text with a formula...?
    By synses in forum Excel General
    Replies: 3
    Last Post: 07-31-2012, 04:30 PM
  2. Adding text to formula
    By arnab0711 in forum Excel General
    Replies: 1
    Last Post: 06-04-2012, 07:33 AM
  3. Adding text to a formula?
    By cocco in forum Excel General
    Replies: 6
    Last Post: 03-08-2012, 01:50 PM
  4. Adding text in same cel as formula??
    By dugexcel in forum Excel General
    Replies: 6
    Last Post: 01-06-2009, 10:05 AM
  5. Adding text to a formula
    By horseman in forum Excel General
    Replies: 3
    Last Post: 04-19-2006, 09:25 AM

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