| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting Characters
So I have a column of zip codes - some with 5 numbers and some with 9. What I am trying to do is create a formula where if there are more than 5 characters in that cell, insert a "-" after the 5th character from the left...does anyone know how to do that? what I am trying to do... befo 503122540 after: 50312-2540 without going through each cell manually! Thanks -- rae820 ------------------------------------------------------------------------ rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135 View this thread: http://www.excelforum.com/showthread...hreadid=573110 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Ranges - what characters are (or are not) allowed in the nam | Excel Discussion (Misc queries) | |||
| How can I control the length of characters a code will return? | Excel Discussion (Misc queries) | |||
| Inserting characters into text already typed | Excel Discussion (Misc queries) | |||
| Formula to replace invalid filename characters | Excel Worksheet Functions | |||
| inserting unicode characters | Excel Discussion (Misc queries) | |||
Threaded Mode
