+ Reply to Thread
Results 1 to 5 of 5

add certain text in a cell between the words

  1. #1
    Registered User
    Join Date
    01-19-2011
    Location
    hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    17

    add certain text in a cell between the words

    hi,
    I'm new to excel.
    I want a macro to add certain text in a cell between the words...
    In the attached example..
    The cell in blue color should display the text which is there in the B1,B2 and if the user selects the Hindu radio button then hindu should be displayed and if the users selects the graduate option the that should be added and finally the comments should be appended in the blue cell when user clicks submit button....
    The text in the blue color should look like this....
    "Bobby is 18 years old. He is a Muslim. He lives in Bombay. He has done graduation from xyz college."

    Your help is greatly appreciated....
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-23-2011
    Location
    George, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: add certain text in a cell between the words

    I suppose the formula would look something like:

    Please Login or Register  to view this content.
    For you other forms, you would also have to do cell links and incorporate that into the formula. If you unprotect the sheet, I could have a look again.

    Have a look to the attached file.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-19-2011
    Location
    hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: add certain text in a cell between the words

    thank you sir,
    I have not protected the sheet..
    when i click on submit button the data should appear in blue cell and i should have one more button called append beside to submit button and when i click the append button i should be able to append the data from the cursor position.. in the blue cell...
    Pls help me sir....

  4. #4
    Registered User
    Join Date
    01-19-2011
    Location
    hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: add certain text in a cell between the words

    Can anyone pls help me.....
    pls find the attachment....
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-19-2011
    Location
    hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: add certain text in a cell between the words

    can anyone plz help with the above one...
    your help is greatly appreciated....

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1