View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Huber57 Huber57 is offline
external usenet poster
 
Posts: 74
Default 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.