How do I format a character from a result of formula in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use PROPER function. eg,
=PROPER(VLOOKUP(A3,emp_data,2,FALSE))

Vikrant
 
You must log in or register to reply here.

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

Conditional formatting in Excel 2010 2
Formula to validate characters within a string of data in aparticular cell 1
Excel 2007 Not returning formula result 2
Excel JUMP FROM SEARCH BAR TO RESULT 3
How do I use a formula result in another formula 2
data from internet not showing up 6
Formulas do not generate result until formula edited 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1

Back
Top