+ Reply to Thread
Results 1 to 3 of 3

excel is expecting a formula as soon as you start typing + then the + will display

  1. #1
    Registered User
    Join Date
    10-19-2015
    Location
    chennai
    MS-Off Ver
    2007
    Posts
    3

    excel is expecting a formula as soon as you start typing + then the + will display

    If i add Plus symbol in text for my reference , the formula follows in next cell while i type plus symbol

    For Example : i need to save text like +Save +my +note , after typing this in first cell , if i continued in next cell means it will reflects like +c9 Save +blog


    the c9 means the cell number . i dont need the cell number to reflect , how to avoid this.

    i need to save my content in excel in this format.


    +save + my.
    +blog + history

  2. #2
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: excel is expecting a formula as soon as you start typing + then the + will display

    Start with the ' (single quote or apostrophe) symbol.
    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.

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: excel is expecting a formula as soon as you start typing + then the + will display

    diva1989,

    if you continue to open duplicated threads after being warned not to do that - I will ban you.
    Thanks for understanding.

+ 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. Start typing from left hand side? (Within Cell)
    By Dagoom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2015, 11:14 AM
  2. Drop down list that will autofill when you start typing
    By Modify_inc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-04-2015, 04:01 PM
  3. [SOLVED] start typing in a cell with a drop down box and have it display matching results
    By gnagystrap in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2013, 03:21 PM
  4. Start typing in cell set up
    By lpratt in forum Excel General
    Replies: 1
    Last Post: 07-18-2013, 11:31 AM
  5. VBA code to start typing in field?
    By soxcrates in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2012, 05:24 PM
  6. [SOLVED] HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN.
    By Trenner in forum Excel General
    Replies: 2
    Last Post: 05-16-2006, 07:33 AM
  7. Newbie: Start Typing not a full replace??
    By Bruce D in forum Excel General
    Replies: 3
    Last Post: 07-28-2005, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1