+ Reply to Thread
Results 1 to 3 of 3

super quick: add extention to url name fix

Hybrid View

  1. 06-10-2013, 01:22 AM #1
    mecutemecute
    mecutemecute is offline
    Registered User
    Join Date
    05-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    38

    super quick: add extention to url name fix

    I need this---> http://test.com/Black-3.jpg to show this---> http://test.com/Black-3-CROP.jpg

    Pretty much add the extention "-CROP" to the end of the name before .jpg.

    thanks!
    Reply With QuoteRegister To Reply
  2. 06-10-2013, 01:24 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: super quick: add extention to url name fix

    Please attach a sample workbook with expected output for better understanding


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 06-10-2013, 01:30 AM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: super quick: add extention to url name fix

    =substitute(A1, ".jpg", "-CROP.jpg")
    Entia non sunt multiplicanda sine necessitate
    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)

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