| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text following an Outlook field insertion
Sheet1.Range("E13").Value = olCi.BusinessTelephoneNumber
& " Tel." Hope this helps someone else. Sorry I am new to VB. Shauna -----Original Message----- I am inserting a field from Outlook into a cell in my worksheet and I want to also have it include the text Tel. after in the contents in the cell. Is this possible? Sheet1.Range("E13").Value = olCi.BusinessTelephoneNumber I would like a result something like: (604) 684-5344 Tel. Thanks! Shauna . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date field from text field | Excel Worksheet Functions | |||
| Trouble sorting first by a dates field and then by a text field. | Excel Discussion (Misc queries) | |||
| Changing a text field to a date field | New Users to Excel | |||
| Exporting a date field in Excel to an Outlook Calendar? | Excel Discussion (Misc queries) | |||
| How to keep leading zero without changing field to text field? | Excel Discussion (Misc queries) | |||
Linear Mode
