Text to Columns?

[Brian]

In my spreadsheet, from cells F1 to CA1, I have a list of
titles. At the beginning of each of these titles is the
words Out of Stock/. I would like to know if there is an
easier way to get rid of these words other than text to
columns. Right now, I insert a column next to one with
text and use Text to Columns and choose "/" as my
separator, and then I have to go back and delete all of
the unwanted cells. I didn't mind doing this once, but
now that I have to do it weekly, I need to find a faster
way. TIA

This is what it looks like now.

F1 G1
Out of Stock/Go Fish Out of Stock/Red Car


What I would like to see......

F1 G1
Go Fish Red Car

 

[Dan E]

Brian,

It's possible that the Find Replace may do what you want
In the Edit Menu choose "Replace..."
In the "Find what:" field type
Out of Stock/
Leave the "Replace with:" field empty
Hit "Replace All"

If the results aren't what you wanted it can be undone with the "Undo"
command.

Dan E

 

[Brian]

works perfect. thanks to all.

-----Original Message-----
Brian,

It's possible that the Find Replace may do what you want
In the Edit Menu choose "Replace..."
In the "Find what:" field type
Out of Stock/
Leave the "Replace with:" field empty
Hit "Replace All"

If the results aren't what you wanted it can be undone with the "Undo"
command.

Dan E




.