Bold certain text in concconate formula

[Excel_Pa]

Hi Team,

Could you advise on, how to achive the desired results as below with the help of formula.

Sl School Name Section First Name Last Name Formula Desired Results
1 NPS A Jon Peter NPS-A Jon Peter NPS-A Jon Peter
2 NLS B Andy Novel NLS-B Andy Novel NLS-B Andy Novel

Attached sample excel for reference.

Thanks in advance.

[bebo021999]

Only VBA can help. Do you want to use VBA?

[bebo021999]

Anyway, here is VBA code:

Please Login or Register  to view this content.

[Excel_Pa]

Hi bebo021999,

Truely amazing, I am getting desired results, Thanks you very much, much appreciated.

[AliGW]

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue 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 each of those who offered help.

[Excel_Pa]

Hi Bebo021999,

Could you create VBA with similar example
Attachment 864191
SL No Date Events Remarks 1 Remarks 2 Desired Results
1 20-03-2024 Admission of Student A Annexure A Annexure - A Admission of Student A, dated 20-03-2024
2 26-03-2024 Admission of Student C Annexure B Annexure - B Admission of Student C, dated 26-03-2024



Attached sample excel for reference.

Thanks in advance.

[jeffreybrown]

You should just be able to swap around some of the elements within the code that bebo021999 suggested. Try this

Please Login or Register  to view this content.

[Excel_Pa]

Hi Jeff, Thank you very much.

it is appearing as below if i use your VBA code
Annexure - A Admission of Student A, 20-03-2024

however i need to prefix ", dated " before date, like below
Annexure - A Admission of Student A, dated 20-03-2024

Could you help me to write vba code...
Thanks in advance

[jeffreybrown]

Post # 7 updated. Please try the code there.

[Excel_Pa]

Thank you very much for quick help, much appreciated.

[jeffreybrown]

You are very welcome and thank you for the feedback!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon 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 those who helped.

[Excel_Pa]

Added reputation...