Text to Columns?

  • Thread starter Thread starter Brian
  • Start date Start date
B

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




.
 
Back
Top