| 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 |
| 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 | |||
Threaded Mode
