I could but then it would split the example below into three cells. I only
want two cells.

Make sense?

"Joel" wrote:

Why can't you just use Text - to column and select OTHER and put in the OTHER
box the dash?

"Huber57" wrote:

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.