I have three columns and arrving at fourth column. Need a part of the fourth column to be bold for over 50k entries. Kindly guide what changes to make to concatenate formula to get this output ?
A B C Formula Needed output
23 today date today date is :23 today date is :23
You can not use a formula to do that. Bold is nothing to do with the value... just its appearance. You can do it with VBA. Is VBA acceptable to you? If so, let me know & I will move the thread for you to the VBA section.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
if not possible with formula then can in vba it be dynamic
I have no idea!! I cannot use VBA... I will move your thread.
I have a feeling that it's not possible to apply this type of formatting to a formula result.concatenate formula to get this output
Re: How to make a part of output of concatenate function Bold
Originally Posted by skasat
So attach at least a workbook better reflecting your original …
Worksheet event is used. If columns are different in your file change the columns in code as required.
Code:
How to use workheet event the code
Please Login or Register to view this content.
Right click on Sheet tab --> view code
Visual Basic (VB) window opens.
Paste the code
Close the VB window.
Save the file as .xlsm
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
@kvsrinivasamurthy
Range.Characters property:
expression.Characters (Start, Length)
Start and Length must be number, so I think it'd be:
Please Login or Register to view this content.
Barriers are there for those who don't want to dream
@vichopalacios
Yes. you are correct.
Code revised is
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks