Format text string in formula result

R

Rukicc

Joined
May 10, 2007
Messages
1
Reaction score
0
I need to format in result of this formula stings: "PrlEmployee_FirstName" and "PrlEmployee_LastName" as bold in result text automaticly without any user action. Or may be is some advanced comand whitch allow insert data from field With formatting?

=IF(Base_Fields!$A$1=1;Base_Fields!$B$2;Base_Fields!$B$3)&" "&IF(Base_Fields!$A$1=1;Base_Fields!$E$2;Base_Fields!$E$3)&", Text0 "&IF(Base_Fields!$A$1=1;Base_Fields!$F$2;Base_Fields!$F$3)&", Text1 "&IF(Base_Fields!$A$1=1;Base_Fields!$G$2;Base_Fields!$G$3) &" Text2 "&IF(Base_Fields!$A$1=1;Base_Fields!$H$2;Base_Fields!$H$3)&" Text3 "&PrlEmployee_FirstName&" "&PrlEmployee_LastName&", code "&PrlEmployee_PersCode&", TEXT"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
About references 1
Reference Cell Altering Formulas 1
Excel Countifs/Sumproduct with mutil Or statement 3
vlookup from right to left 2
How to get the following data ... How to create the formula for below 1
Figuring out a lengthy formula. Probably quite simple... 3
SUMIF where the IF is a variable date from data in a column HOW? 3

Top