| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert "-" as fourth character in number string
=LEFT(A1,3)&"-"&RIGHT(A1,LEN(A1)-3)
-- David Biddulph "cursednomore" wrote in message ... I have 8700 rows of numerical data, and I would like to insert a "-" as the fourth character from the left in each cell, so that 101394 becomes 101-394, and 1011001403 becomes 101-1001403. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| remove cr character from a + number and change number to - 159cr | Excel Worksheet Functions | |||
| help with excel number string | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| Insert row number into a cell? | Excel Worksheet Functions | |||
Hybrid Mode
