| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace first hyphen in a cell
All:
I have searched the posts and on Google but I can't find the answer. I have a cell: Kemet - ECJ-1238FG47KGCH1 I want to replace only the first hyphen in the cell with a | so I can use Text to Columns. Is there a better way? Thanks much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hyphen to text in cell | Excel Discussion (Misc queries) | |||
| Cell format - put hyphen where zero value would be. | New Users to Excel | |||
| hyphen (nit minus) in cell | Excel Discussion (Misc queries) | |||
| Entering a hyphen into a cell | Excel Worksheet Functions | |||
| many numbers in one cell separated by hyphen. | Excel Discussion (Misc queries) | |||
Threaded Mode
