How can I change a text value in a column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I assign a category to an email I am composing? 1
Date Columns for Folder View 2
Calculating working days between dates. 3
How do I stop incoming email to a backup computer 2
How can I set up my email STMP and POP servers? 7
Sending Issues 2
How can I prevent a cell, once calculated from being recalculated? 1
Changing a fields resulting text 2

Back
Top