Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change a text value in a column?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change a text value in a column?
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") "Tom Bradstreet" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change a text value in a column?
Thank You Tim. That worked perfectly.
Tom "tim m" wrote: 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") "Tom Bradstreet" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Color Change prompted by different columns | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Change column Number vrs Text | Excel Worksheet Functions |