+ Reply to Thread
Results 1 to 11 of 11

Changing/Amending Text String In Cell

  1. 02-19-2011, 05:34 AM #1
    Kumara_faith
    Kumara_faith is offline
    Forum Contributor
    Join Date
    08-19-2006
    MS-Off Ver
    Excel 365
    Posts
    229

    Changing/Amending Text String In Cell

    Hi,

    I have the following text that needs to be changed:

    Scenario 1
    Original Text
    Type-MHH Houston Terminal

    Change To
    MHH Type Houston Terminal

    Scenario 2
    Original Text
    MHH Mall Type Houston

    Change To
    Mall Houston

    Is there a formula that I could use to change the text ? The original list is very long and I need a formula to make the change. Is this possible ?

    Appreciate all the help.

    I have a cross post here:
    http://www.mrexcel.com/forum/showthread.php?t=530381
    Reply With QuoteRegister To Reply
  2. 02-19-2011, 05:52 AM #2
    Rahul Nagar
    Rahul Nagar is offline
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465

    Re: Changing/Amending Text String In Cell

    Hi

    Fist use text to column function and that apply =concatenate formula.
    __________________
    Regards
    Rahul Nagar
    Founder of www.myshortcutkeys.com.

    If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
    Also
    If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
    Reply With QuoteRegister To Reply
  3. 02-19-2011, 05:59 AM #3
    Kumara_faith
    Kumara_faith is offline
    Forum Contributor
    Join Date
    08-19-2006
    MS-Off Ver
    Excel 365
    Posts
    229

    Re: Changing/Amending Text String In Cell

    Hi Rahul,

    My apologies for the inconvenience.

    The same column houses both scenario. How would I able to use text to column ?
    Reply With QuoteRegister To Reply
  4. 02-19-2011, 06:06 AM #4
    Rahul Nagar
    Rahul Nagar is offline
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465

    Re: Changing/Amending Text String In Cell

    Quote Originally Posted by Kumara_faith View Post
    Hi Rahul,

    My apologies for the inconvenience.

    The same column houses both scenario. How would I able to use text to column ?
    Please attach some sample sheet
    Reply With QuoteRegister To Reply
  5. 02-19-2011, 06:33 AM #5
    Kumara_faith
    Kumara_faith is offline
    Forum Contributor
    Join Date
    08-19-2006
    MS-Off Ver
    Excel 365
    Posts
    229

    Re: Changing/Amending Text String In Cell

    Hi Rahul,

    Please find attached a sample sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-19-2011, 06:45 AM #6
    Rahul Nagar
    Rahul Nagar is offline
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465

    Re: Changing/Amending Text String In Cell

    check the attached file and let me know if there any thing else.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 02-19-2011, 07:00 AM #7
    Kumara_faith
    Kumara_faith is offline
    Forum Contributor
    Join Date
    08-19-2006
    MS-Off Ver
    Excel 365
    Posts
    229

    Re: Changing/Amending Text String In Cell

    Hi Rahul,

    Thank you for the reply.

    The actual list is not in the order as attached. It very random as follows:


    Type-MHH Houston Terminal
    Type-MHH Houston Terminal
    Type-MHH Houston Terminal
    MHH Mall Type Houston
    MHH Mall Type Houston
    Type-MHH Houston Terminal
    MHH Mall Type Houston

    Does this mean that I have to enter the formula manually for each row? My apologies for not mentioning this earlier.
    Reply With QuoteRegister To Reply
  8. 02-19-2011, 07:04 AM #8
    Rahul Nagar
    Rahul Nagar is offline
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465

    Re: Changing/Amending Text String In Cell

    Just short your data by "Mall" and "MHH"
    then do text to column and paste =concatenate formula.

    if you do not want to change the order then insert one column and put numbering.
    once you have done with your formula then again short by number.
    Reply With QuoteRegister To Reply
  9. 02-19-2011, 07:15 AM #9
    StuH
    StuH is offline
    Registered User
    Join Date
    02-19-2011
    Location
    Hong Kong
    MS-Off Ver
    Microsoft 365 subscription
    Posts
    17

    Re: Changing/Amending Text String In Cell

    Can you not use Ctrl F and find all replace all?
    Reply With QuoteRegister To Reply
  10. 02-19-2011, 07:17 AM #10
    Rahul Nagar
    Rahul Nagar is offline
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465

    Re: Changing/Amending Text String In Cell

    I think that will reply all the data...... and Kumara want's some specific format.
    Reply With QuoteRegister To Reply
  11. 02-19-2011, 10:44 AM #11
    Kumara_faith
    Kumara_faith is offline
    Forum Contributor
    Join Date
    08-19-2006
    MS-Off Ver
    Excel 365
    Posts
    229

    Re: Changing/Amending Text String In Cell

    Hi Rahul,

    Thank you for your reply. That will work. Appreciate your time and patience on this !
    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