Hi Joseph
formula in cell A40 =TEXT(A1,"0% "&A24)
On Sat, May 26, 2012 at 1:21 AM, Mahesh parab wrote:
> Hi Joseph
>
> In cell A40 try below formula & run below macro
> =CONCATENATE(TEXT(A1,"0% "&A24))
>
> Sub Mtest()
> With Range("A40")
> .Value = .Value
> End With
> With Range("A40").Charac
Hi Joseph
In cell A40 try below formula & run below macro
=CONCATENATE(TEXT(A1,"0% "&A24))
Sub Mtest()
With Range("A40")
.Value = .Value
End With
With Range("A40").Characters(Start:=1, Length:=3).Font
.FontStyle = "Bold"
End With
With Range("A40").Characters(Start:=5, Length:=1).Font
.FontStyle
Not possible as far as I know
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of joseph.cam...@gmail.com
Sent: 26 May 2012 12:13
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
Dear Joseph,
Please see attached sheet..
*=IF(AND(IsBold,IsItalic)=TRUE,CONCATENATE(A2," ",B2),"")*
create a Name range
*IsBold* =GET.CELL(20,INDIRECT("RC[-2]",)) *IsItalic*
=GET.CELL(21,INDIRECT("RC[-1]",))
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacrowo
You can do something like:
range(cell).characters(1 to 3).font.bold = true
And the same for characters 6 but Ruth italics
Sent from my iPhone
On 25 May 2012, at 19:43, joseph.cam...@gmail.com wrote:
> Hi,
>
> I have concatenated two values.
> E.g., cell A1 has 12%, and A24 has 1. I want to
No can do in FORMULAS. Convert to value and then change format. Develop a
macro to do it for you.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: joseph.cam...@gmail.com
Sent: Friday, May 25, 2012 1:43 PM
To: excel-macros@googlegroups.
