+ Reply to Thread
Results 1 to 4 of 4

Suffix words

  1. 07-10-2022, 03:16 AM #1
    bittubadri
    bittubadri is offline
    Forum Contributor
    Join Date
    10-18-2019
    Location
    Mumbai
    MS-Off Ver
    OFFICE 2010
    Posts
    427

    Post Suffix words

    B8 & B9 contains some words/alphabets.
    In B10, I want to suffix ‘all’ words/alphabets of B8 (after giving a space) with B9.
    Example:
    B8=Son & daughter
    B9=I like my

    So B10=I like my Son & daughter

    How to accomplish?
    Reply With QuoteRegister To Reply
  2. 07-10-2022, 03:19 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,563

    Re: Suffix words

    Like this:

    =B9&" "&B8
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-10-2022, 03:52 AM #3
    bittubadri
    bittubadri is offline
    Forum Contributor
    Join Date
    10-18-2019
    Location
    Mumbai
    MS-Off Ver
    OFFICE 2010
    Posts
    427

    Re: Suffix words

    Yes Ali Thanks
    Reply With QuoteRegister To Reply
  4. 07-10-2022, 04:06 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,563

    Re: Suffix words

    Glad to have helped.

    Remember that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    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)

Similar Threads

  1. extract last one or multiple consecutive words as suffix from text string
    By excelkbhalla in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2019, 04:10 PM
  2. Write the specific value of the words in the statement (no prefix or suffix)
    By gozparlak in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-13-2017, 07:34 AM
  3. VBA To Create Suffix
    By bilbo85 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2015, 08:29 PM
  4. [SOLVED] Need to add a text suffix to the end of "all words" by searching for their prefix
    By lorilewis07 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2015, 01:01 PM
  5. [SOLVED] Changing a positive or negative value based on the input's suffix, then removing suffix
    By Theredwind in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2014, 05:19 AM
  6. How do I had a suffix to a cell i.e. -1,-2,-3?
    By controller_woman in forum Excel General
    Replies: 1
    Last Post: 07-12-2005, 01:05 PM
  7. [SOLVED] I'd like to add a suffix...
    By Dr. Darrell in forum Excel General
    Replies: 4
    Last Post: 06-18-2005, 12: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1