Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting a dash into cells
I am importing data from an old DOS system. I am trying to add a formula so
that numbers that import at "12345 678" can be reformatted to "12345-678". I can import the two sets of numbers as one or two columns which ever will let me accomplish the task. Help please! Thanks, TJ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting a dash into cells
If you could import as 2 columns you can easily concatenate the numbers.
So in your example if those numbers were in A1 and B1 you would put the formula in C1 =A1&"-"&B1 "tjackson" wrote: I am importing data from an old DOS system. I am trying to add a formula so that numbers that import at "12345 678" can be reformatted to "12345-678". I can import the two sets of numbers as one or two columns which ever will let me accomplish the task. Help please! Thanks, TJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a range of cells | Excel Worksheet Functions | |||
inserting clip art into cells | Excel Discussion (Misc queries) | |||
inserting a dash into a column of numbers | Excel Worksheet Functions | |||
Inserting cells between cells with text | Excel Discussion (Misc queries) | |||
understanding dash dash in a excel formula | Excel Worksheet Functions |