How can I modify these cells?

  • Thread starter Thread starter Vic Baron
  • Start date Start date
V

Vic Baron

I have a column of data that contains "Franklin Fund - Dividend Earned" in
each cell.

Is there a way to remove the "- Dividend Earned" from each cell without
manually editing individual cells?

MANY years ago there was a spreadsheet called QuattroPro which, IIRC, had a
way to highlight a 'column within a column' and delete it.

Of course I can do it manually but it will be a big time consumer.

Thanx!

Vic Baron
 
Vic Baron said:
I have a column of data that contains "Franklin Fund - Dividend Earned" in
each cell.

Is there a way to remove the "- Dividend Earned" from each cell without
manually editing individual cells?

MANY years ago there was a spreadsheet called QuattroPro which, IIRC, had
a way to highlight a 'column within a column' and delete it.

Of course I can do it manually but it will be a big time consumer.
Click to expand...

Find and Replace. Find "Franklin Fund - Dividend Earned", replace with
"Franklin Fund "
 
Gordon said:
Find and Replace. Find "Franklin Fund - Dividend Earned", replace with
"Franklin Fund "
Click to expand...

LOL! Now I know how it feels when I give someone a simple answer to a
problem. I guess I just didn't think of a spreadsheet as a text document.

Duh!

Thanx - it's so obvious that I probably would have continued to overlook it.

Vic
 
Data>Text to Columns>Delimited by>Other. Enter a hyphen(dash) then Next

In this window select the second column and choose to skip it then Finish.


Gord Dibben MS Excel MVP
 
Thanks for the feedback.

Data>Text to Columns can be used for many functions.

Did you know that running bogus text dates through T to C can convert them to
recognizable dates in most cases?


Gord
 
Back
Top