Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format portion of formula
I have a person's name. Current format is last name space first name, all in
caps. What I need to do is separate the first and last name, add a comma and space after the last name then have the first name all in one cell. This is done, no problems to this point. My problem lies with formatting. I have been asked to have the first letter of the last and first name in caps and the rest in lower case. In addition, the full last name needs to be in bold while the rest of the cell contents are in regular format. I am not real familiar with the macro world, but I'm not scared of it either if it will make it easier (it will just have to be spelled out). Formulas I can work with readily. Can anyone please help with getting this done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace a portion of a formula | Excel Discussion (Misc queries) | |||
Format portion of plot area | Charts and Charting in Excel | |||
Return portion of Formula? | Excel Discussion (Misc queries) | |||
A formula for moving a portion of a cell??? | Excel Discussion (Misc queries) | |||
how do i extend the series of a portion of a formula? | Excel Worksheet Functions |