Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I format a character from a result of formula in excel?
for example we can get the employee names using VLOOKUP function by entering
employee numbers. At the result cell where we have enter the formula, the first character should be BOLD, is it possible. I tried with conditional format, LEFT, MID, etc. wasn't succeed. Is there any possible way?. please let me know. |
#2
|
|||
|
|||
Use PROPER function. eg,
=PROPER(VLOOKUP(A3,emp_data,2,FALSE)) Vikrant "Mohamed" wrote: for example we can get the employee names using VLOOKUP function by entering employee numbers. At the result cell where we have enter the formula, the first character should be BOLD, is it possible. I tried with conditional format, LEFT, MID, etc. wasn't succeed. Is there any possible way?. please let me know. |
#3
|
|||
|
|||
Hi
you can't format the result of a formula with a function. "Mohamed" wrote: for example we can get the employee names using VLOOKUP function by entering employee numbers. At the result cell where we have enter the formula, the first character should be BOLD, is it possible. I tried with conditional format, LEFT, MID, etc. wasn't succeed. Is there any possible way?. please let me know. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why can I not format a secondary axis in excel x? | Charts and Charting in Excel | |||
How can I pre format all Excel comments to Tahoma, font size 12, . | Excel Discussion (Misc queries) | |||
Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) | |||
Preserve Excel formula entry | Excel Discussion (Misc queries) | |||
nunber format in Excel 2000 | Excel Discussion (Misc queries) |