+ Reply to Thread
Results 1 to 10 of 10

Editing all Cells in a selected range.

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    2010
    Posts
    72

    Editing all Cells in a selected range.

    Hello,

    How do I edit all cells which I have selected? I want to add "/MSNORDL" to the end of all values in a range of 234 cells. I know there is a shortcut command for this but I can't seem to find it.


    Thanks in advance,
    Joachim
    Last edited by Joachimjr; 07-09-2014 at 04:49 AM.

  2. #2
    Registered User
    Join Date
    06-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    2010
    Posts
    72

    Re: Editing all Cells in a selected range.

    Nevermind, I found it. ctrl+H was the command I was looking for.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Editing all Cells in a selected range.

    Quote Originally Posted by Joachimjr View Post
    Nevermind, I found it. ctrl+H was the command I was looking for.
    I am just curious to know how you will add the text "/MSNORDL" to the end of all values using the above approach?


    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

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Editing all Cells in a selected range.

    Hi Sixthsense ,

    as per me he is going to replace "/MSNORDL" with ""/MSNORDLxxxzzxxz".

    Punnam

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Editing all Cells in a selected range.

    Quote Originally Posted by Punnam View Post
    as per me he is going to replace "/MSNORDL" with ""/MSNORDLxxxzzxxz"
    Ah!!! If that is the case then it's possible, but adding something in the end of each cells value using find and replace is not possible. That is what I wanted to highlight to the OP

    Thanks for clarifying it to me

  6. #6
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Editing all Cells in a selected range.

    Hi Sixthsense,

    Thanks for the rep. i have't expected this at all.

    Punnam

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Editing all Cells in a selected range.

    Quote Originally Posted by Punnam View Post
    Thanks for the rep. i have't expected this at all.
    Here adding reps is the way of saying Thanks!!!

  8. #8
    Registered User
    Join Date
    06-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    2010
    Posts
    72

    Re: Editing all Cells in a selected range.

    No, I have the word "XXXX", I wanted to edit all selected cells like this "XXXX/MSNORDL". But it's the same like "/MSNORDLXXXX". Just the other way around.

  9. #9
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Editing all Cells in a selected range.

    Hi Joachimjr,

    Thanks for the clarification

  10. #10
    Registered User
    Join Date
    06-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    2010
    Posts
    72

    Re: Editing all Cells in a selected range.

    No problem, sorry for being unclear when I created the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Loop backwards through selected range - delete entire row from selected cells
    By scottbass in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2014, 09:21 AM
  2. Getting the content of cells in a row ABOVE a selected range..in VBA
    By seigna in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-08-2013, 02:06 PM
  3. Getting the range of the selected cells
    By ballack in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2007, 04:23 AM
  4. Set Range Using Selected Cells
    By Paputxi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2006, 01:35 PM
  5. Compare a selected Range with a Named range and select cells that do not exist
    By PCLIVE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2005, 03:05 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