Replace first hyphen in a cell
With your data in cell A1 try the below to remove the first hyphen
=SUBSTITUTE(A1,"-","",1)
If this post helps click Yes
---------------
Jacob Skaria
"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.
|