| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to insert hyphen "-" in between two numbers
Hi All:
I was wondering if one of you Excel guru's out there could coach me through this challenge I have. I run an extract report from our business system into Excel and I need to have a particular column of data changed as follows: From: 06001 To: 06-001 Is there a formula of some sort that I could write to handle inserting the hyphen "-" in between the 2nd and 3rd character of my data column to accomplish this? Please help. Thanks, Big Cat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert currency numbers from spreadsheet such as 48 = $48.00 | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| how do I insert an ' in front of many rows of numbers? | Excel Discussion (Misc queries) | |||
| How do I insert blinking or flashing numbers or text in Excel? | Excel Worksheet Functions | |||
Threaded Mode
