| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Prefix
Dear all,
Suppose I want to input an extension number (e.g. 61151) in cell A1 then I want a full telephone number appears in B1. Our telephone prefix is 4255 so the full telephone number should be 4255 1151. My formula in B1 is: =IF(LEFT(A1)=6,"4255"&RIGHT(A1,4),"") Why I use LEFT(A1)=6 becuase I have another set of extension numbers start with 4. However, the result of the above formula returns a blank cell. Where is the mistake? Please kindly advise. Thanks & regards. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding a prefix to cells | Excel Discussion (Misc queries) | |||
| Adding a prefix to all numbers in a column. | Excel Discussion (Misc queries) | |||
| adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
| Adding zero prefix to no's | Excel Discussion (Misc queries) | |||
| Adding a prefix to a cell by using a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
