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.

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.

Hi,
you don't need to replace the Hyphen to use text to columns just go to text
to columns,delimited, others

but if you want to replace it do

CTRL H
find what Hyphen, replace with

if this helps please click yes, thanks

"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.

On Jun 3, 1:38*pm, 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.

Have you tried the SUBSTITUTE function?

=SUBSTITUTE(A1,"-","X",1)

Assuming the text string that you posted above is in cell A1, and you
want to replace the hypen with an X, that will work.

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.

=SUBSTITUTE(A1,"-","|",1)

"Huber57" wrote in message
...
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.

As I re-read my first post, I don't think i was clear.

I have a column of cells. In that column, there is a manf. name and manf.
part number separated by a hyphen. I would like to split them out using text
to columns. Unfortunately, the manf. number could also have a hyphen. My
thought was to replace the hyphen that divides the two with another character
I know is not in the manf part number.

Does that help?

"Eduardo" wrote:

Hi,
you don't need to replace the Hyphen to use text to columns just go to text
to columns,delimited, others

but if you want to replace it do

CTRL H
find what Hyphen, replace with

if this helps please click yes, thanks

"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.

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.

Perfect. Thanks much!



"Bob Umlas" wrote:

=SUBSTITUTE(A1,"-","|",1)

"Huber57" wrote in message
...
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.