Results 1 to 9 of 9

Edit and replace long text in a single cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    IDN
    MS-Off Ver
    2007 & 2010 & 2013
    Posts
    48

    Edit and replace long text in a single cell

    Hy all

    i attached some file

    in this file, ther's old text and new text coloumn which contain long text in a cell

    to make it clear, i attach a picture
    Untitled.jpg

    how to replace a specific text:
    1. the name XXX with cell B3
    2. username with with cell C3
    3. password with cell D3

    the output is just like New text

    thankyou so much for the help
    Attached Files Attached Files
    Last edited by adekinteristi; 12-21-2017 at 04:00 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] edit/replace text based on ranges of data
    By jwmanners in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2016, 08:24 AM
  2. [SOLVED] Userform text box to display and edit a single cell only
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 11-25-2013, 08:50 AM
  3. edit and replace a text string in within a cell
    By mtojek in forum Excel General
    Replies: 4
    Last Post: 02-09-2012, 10:52 AM
  4. Search and replace text in cell with single character
    By piputty in forum Excel General
    Replies: 1
    Last Post: 08-05-2011, 10:32 PM
  5. [SOLVED] Replace with single tick - formula too long....
    By te@ivorypetal.com in forum Excel General
    Replies: 1
    Last Post: 03-27-2006, 12:25 PM
  6. [SOLVED] Performance long/single comparison vs converting single to long
    By George Nicholson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2005, 02:05 PM
  7. Cannot replace text in cell: "Formula is too long"
    By lianasal in forum Excel General
    Replies: 0
    Last Post: 05-18-2005, 01:20 PM

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