Results 1 to 3 of 3

Convert first 3 letters into desired one in the formula cell.

Threaded View

  1. 07-30-2010, 05:03 AM #1
    PRADEEPB270
    PRADEEPB270 is offline
    Forum Contributor
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2019
    Posts
    339

    Convert first 3 letters into desired one in the formula cell.

    Please look the below datas:-

    CNDDRSSCRRBK CND
    CNDKDRKCCRBRD CND
    CNSKDRKSCRRBK CNS
    PAPDRKCCRFBK PAP
    PAPDRKCCRPMR PAP
    PPOHDRKCCRSRD PPO
    PPRHDRKSCRFBK PPR
    SPSJDRSCCRBRD SPS
    SPSJDRSCCRSBK SPS

    I am applying the formula in cell B1, Left(A1,3) and result are CND.....SPS.But I want convert to PPO and PPR into PAP letters in the same column by formula i.e.B column.Is it possible?Please see the attach file for working and more clarification


    Regards

    Pradeep Kumar Gupta
    Attached Files Attached Files
    Last edited by PRADEEPB270; 07-30-2010 at 05:21 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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