| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Replace one cell w/another cell unequal occurrences
Sorry if the subject is confusing. I exported a report from Crystal reports
to CSV. After aligning the columns properly, I end up with the one row having the info I need and the next row having unneeded info. As an example: AcctNbr1 Balance AcctNbr2 Balance Balance AcctNbr3 AcctNbr4 There are 4,000 rows. How can I copy the info from one cell (AcctNbr) to the cell(s) with the unneeded info (Balance). Each AcctNbr field is unique and identifies the data in the remaining cells of that row. Thank you. -- Für Elise - Support the Breast Cancer & Heart Foundations |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| Find and replace in a different cell | Excel Worksheet Functions | |||
| I can't see Highlight cell in Find & Replace Cell | Excel Discussion (Misc queries) | |||
| find replace the 1st character in a cell | Excel Discussion (Misc queries) | |||
| Find a value in one cell and Replace in another cell | Excel Discussion (Misc queries) | |||
Threaded Mode
