| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding & Replacing a list of Data in Multiple Columns
I have a large amount of data that I have to replace in an excel spread
sheet. The columns look like: Old New Column A Column B Column A Column B 0012705 E200 3411 B0108 0012705 E200 3411 B0108 0012705 E200 3411 C0012 0012705 E200 3411 F1023 0012705 E200 3411 E3564 0012705 E200 3411 G8795 0012705 E200 3411 H5423 I either need to delete the information in Old Column A or B or replace Old Column B with the new Column B. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding & Replacing a list of Data in Multiple Columns
Where does the new Column B come from?
Pete On May 5, 3:46*am, Me wrote: I have a large amount of data that I have to replace in an excel spread sheet. *The columns look like: * * * * * * * * *Old * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * New Column A * * * * * Column B * * * * * * * * * * * * * * * *Column A * * * * * * *Column B 0012705 * * * * * * E200 3411 B0108 * * * * * * * * * *0012705 * * * * * * E200 3411 B0108 0012705 * * * * * * E200 3411 C0012 * * * * * * * * * *0012705 * * * * * * E200 3411 F1023 0012705 * * * * * * E200 3411 E3564 * * * * * * * * * *0012705 * * * * * * E200 3411 G8795 0012705 * * * * * *E200 3411 H5423 I either need to delete the information in Old Column A or B or replace Old Column B with the new Column B. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Data into columns without replacing the columns with data | New Users to Excel | |||
| replacing contents of a cell with data froma list/file | Excel Worksheet Functions | |||
| Help needed replacing multiple cells from a list of values. | Excel Discussion (Misc queries) | |||
| Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
Linear Mode
