| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
concatenate
I tried adding a hyphen using a previous help screen to no avail. I have
an 11000 line spreadsheet containing one column with 7 digits. I need to add a hyphen to the 6th position from the left. Any ideas? -- Message posted via http://www.officekb.com |
|
#2
|
|||
|
|||
|
So, you need 6 digits left of the hyphen and 1 to the right, or 5 and 2?
=LEFT(TRIM(A6),6)&"-"&RIGHT(TRIM(A6),1) Change the 6 & 1 above if you want 5 left and 2 right "Christy Quesenbery via OfficeKB.com" wrote: I tried adding a hyphen using a previous help screen to no avail. I have an 11000 line spreadsheet containing one column with 7 digits. I need to add a hyphen to the 6th position from the left. Any ideas? -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
| space between text strings with concatenate | Excel Discussion (Misc queries) | |||
| Concatenate Function will not work | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Linear Mode
