Hi Rahul, You can do this with the help of replace option.
Ist open the replace option by pressing ctrl + H. 2nd on "Find What" option write abc or any text you want to bold. 3rd on "Replace With" write abc or any text you want to bold. 4th on the right hand side of the "Replace with" option you will find "Format" option. From here you can chose any kind of format you want to replace with. 5th after selection the type of format, press the "Replace All" button. Hope this will sort your problem Thanks Simran On Sun, Nov 28, 2010 at 7:56 PM, Rahul Kamal Gandhi <myname.ra...@gmail.com>wrote: > Guys, Can anyone Help me to Bold the text with the help of Formula > > Eg. > > A1 Cell Contains "ABC" > > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) > > And My output should be *ABC* But in Bold Format > > > Any Formula or Code. Please Guys I am Struck > > > > Regards, > Rahul Gandhi > +91-9711772297 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
