Results 1 to 5 of 5

Help with a simple formula, deleting characters

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2010
    Location
    Surrey
    MS-Off Ver
    Excel 2007
    Posts
    26

    Help with a simple formula, deleting characters

    Hello, I have these filenames....

    Searchbtnselect ^AGR000020.png
    Visited ^AGR000021.png
    Height ^AGR000022.png
    Audiooff ^AGR000023.png
    Audioon ^AGR000024.png
    Background ^AGR000025.png
    ...and so on

    What formula will delete 9 characters after and including the ^.

    So i ultimately want this in the next column.

    Searchbtnselect.png
    Visited.png
    Height.png
    Audiooff.png
    Audioon.png
    Background.png


    THANK in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Deleting certain characters
    By Ghoztrider in forum Excel General
    Replies: 4
    Last Post: 08-08-2012, 09:30 PM
  2. Deleting first characters from a cell
    By sheenyp in forum Excel General
    Replies: 2
    Last Post: 11-11-2010, 08:42 AM
  3. deleting the first 8 characters in vba
    By manforeyes in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-02-2009, 05:42 PM
  4. Deleting characters that are not numbers
    By jermsalerms in forum Excel General
    Replies: 4
    Last Post: 01-12-2006, 04:10 PM
  5. deleting characters
    By PLPE in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2005, 09:03 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