+ Reply to Thread
Results 1 to 5 of 5

Formula to remove spacebars at the end of user input text

  1. 04-01-2014, 06:28 PM #1
    NS4Excel
    NS4Excel is offline
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Formula to remove spacebars at the end of user input text

    Can someone please tell me the formula to remove the blank spaces at the end of text that someone enters? I can't remember what it is and a co-worker needs it. Thanks.
    Reply With QuoteRegister To Reply
  2. 04-01-2014, 06:33 PM #2
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Formula to remove spacebars at the end of user input text

    There is a TRIM() Function
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
  3. 04-01-2014, 06:35 PM #3
    NS4Excel
    NS4Excel is offline
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Formula to remove spacebars at the end of user input text

    Can you give me a formula to enter into cell B1 if the text in A1 is "This is a test "?
    Reply With QuoteRegister To Reply
  4. 04-01-2014, 06:36 PM #4
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Formula to remove spacebars at the end of user input text 

    Please Login or Register  to view this content.
    Give this a try
    Reply With QuoteRegister To Reply
  5. 04-01-2014, 06:39 PM #5
    NS4Excel
    NS4Excel is offline
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Formula to remove spacebars at the end of user input text

    So simple yet I missed it. Thank you judgeh59!
    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. Automatic Formula Input Based on User Input Using a Macro
    By Drayloc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2012, 12:10 PM
  2. Using text box input to lookup number and replace based on user input into new column
    By harl3y412 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2011, 03:15 PM
  3. Macro run after user finish input text box
    By celticpucca in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2011, 10:19 AM
  4. User Input text Colour?
    By ets2k9 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-09-2010, 08:41 AM
  5. Showing * instead of text in user input box.
    By CJPHX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2010, 02:55 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