Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO: In a formula, how to change the format of the resulting te
Are you saying that the text changes to lower case when you use the formula?
egardless to have upper case you can use =UPPER(A1)" "&A2 -- Regards, Peo Sjoblom "Kevin McCartney" wrote in message ... Hi TWIMC I need to how to change a proportion of text in a resulting concatenation formula. cell A1 contains the text in bold "ABCDEF", cell A2 containes "GHIJKLM" cell A3 contains =A1 & " " & A2 but I want the cell A1 part to remain in bold. Is there a way of using the TEXT function e.g. =TEXT(A1,BOLD) & " " & A2? TIA KM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change formula bar settings | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |