| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert spaces in String of Numbers
Hello, I have a series of 16 numbers and would like to insert spaces or
dashes. Is there a formula that can be used to accomplish this task. My number appears from the report as: pp234567890123. I would like pp2-345-678901-23. Thanks for your time. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert spaces in String of Numbers
Use the LEFT, MID and RIGHT functions
=left(a2,3)&"-"&mid(etc -- Don Guillett SalesAid Software "Marianne" wrote in message ... Hello, I have a series of 16 numbers and would like to insert spaces or dashes. Is there a formula that can be used to accomplish this task. My number appears from the report as: pp234567890123. I would like pp2-345-678901-23. Thanks for your time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto insert page breaks in Excel, based on a sort of numbers | Excel Discussion (Misc queries) | |||
| Insert a Seperator into a number string. | Excel Discussion (Misc queries) | |||
| string of numbers | Excel Worksheet Functions | |||
| How do I insert blinking or flashing numbers or text in Excel? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
