How can I change a text value in a column?

T

Tom Bradstreet

I have downloaded our company cell phone bill. I need to break out incoming
& outgoing calls for analysis. I have a "From" column that lists incoming
calls as "Incoming" and outgoing by the city that is being called.

What I would like to do is replace all the city names with "Outgoing" .
This will give me a column that is either Incoming or Outgoing.
I'm not sure how this can be done.

I am using Excel 2003 SP2

Thanks
Tom
 
T

tim m

you could copy the following formula into a new column and copy it down.
(The formula assumes your data starts in A2) It will check to see if the cell
says Incoming, if so it will display Incoming, it contains anything else it
will display Outgoing.

=IF(A2="Incoming",A2,"Outgoing")
 
T

Tom Bradstreet

Thank You Tim. That worked perfectly.

Tom

tim m said:
you could copy the following formula into a new column and copy it down.
(The formula assumes your data starts in A2) It will check to see if the cell
says Incoming, if so it will display Incoming, it contains anything else it
will display Outgoing.

=IF(A2="Incoming",A2,"Outgoing")
Click to expand...
 
Top