| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Address must be 18 characters long
Hi all again
I need the address to be 18 characters long i.e. if the address is over 18 characters then chop it, if its under, then add spaces Is this possible? Thanks as always Derek |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display only n numbers of characters for long text? | Excel Worksheet Functions | |||
| Extracting certain characters from a long string | Excel Worksheet Functions | |||
| Validation - Precede with LR and between 6 and 9 characters long. | Excel Discussion (Misc queries) | |||
| How to enter a long address to new web query | Excel Discussion (Misc queries) | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
![Derek M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
