LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default HOW TO FORMATE PART OF TEXT FROM TEXT STRING

Hi,
Thanks a lot in advance for your help which will help me a lot.

I wanna to bold the part of text from the text string which is in one
cell,this is the string which is joined from different cells into one cell by
using function "CONCATENATE".

Here is the formula to be used
=CONCATENATE("I have ",C42," Rs with me.")
result ;
I have 500 Rs with me.

I wanna to do "500" bold, is there any way for this.

Waiting for the reply,
Regards,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to return part of a text string luvthavodka Excel Discussion (Misc queries) 9 October 20th 08 05:27 PM
Extract part of a text string Martin B Excel Worksheet Functions 7 January 13th 08 04:36 PM
Omitting right part of text string klysell Excel Worksheet Functions 6 January 13th 08 12:59 PM
How do I extract part of a text string Brennan Excel Discussion (Misc queries) 2 November 28th 06 07:26 PM
removing part of text string to another cell jamie_k Excel Discussion (Misc queries) 2 July 24th 06 10:57 AM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"