+ Reply to Thread
Results 1 to 3 of 3

How to Remove Characters from Text..?

  1. #1
    Registered User
    Join Date
    07-22-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    11

    Red face How to Remove Characters from Text..?

    I want to remove everything in a cell after 120 Characters?

    I know the following, however thats -before and after -. I tried using * and + but can seem to get it to work. Could you tell me what the formula should look like base on my request?

    Remove characters from text.jpg

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,932

    Re: How to Remove Characters from Text..?

    =mid(a1,1,120)
    Should work for you.

  3. #3
    Registered User
    Join Date
    07-22-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: How to Remove Characters from Text..?

    Quote Originally Posted by davesexcel View Post
    =mid(a1,1,120)
    Should work for you.
    Dave, it sure did...thanks, pal!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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