Results 1 to 4 of 4

Formula needed to extract/delete "PS" text in only certain cells

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    nashville, tn
    MS-Off Ver
    Excel 2010
    Posts
    23

    Formula needed to extract/delete "PS" text in only certain cells

    I need to extract/delete the first two letters (which are "PS") that are in many of the cells- but not all.

    If you look at the attachment, column A has the employee ID's. Some of the cells -as part of the export- placed a "PS" in the very front of the ID. I need to delete the first two letters in ONLY the cells that contain "PS" as the first two letters. The rest of the ID should then be populated in column B. And in the case where there is not a cell that contains a "PS" as the first two letters, that would just simply be "copied" into column B.

    Any help would be greatly appreciated. Thanks!
    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] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2013, 05:36 PM
  2. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  3. Replies: 1
    Last Post: 10-22-2012, 09:38 AM
  4. Delete Row if Cells in specifc Column Equals "X" Macro Needed
    By Ivanur55 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 02:23 PM
  5. Replies: 6
    Last Post: 11-01-2007, 11:56 AM

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