| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text entry help
I have two columns of names (his & hers) and I would like to establish
a column with both names connected by "&". I have accomplished this but would like to have just his name if there is no her. Here is my current formula C2&" & "&E2 How can I eliminate the "7" and "E2 if there is a blank in E2 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| truncating text strings of different lengths | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Prepending text to a cell entry | Excel Worksheet Functions | |||
Threaded Mode
