Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm reposting this. Hopefully I can state my issue more clearly and someone
can get me started. In column A I have a list of ordered numbers. In column B is text which corresponds to column A. The rest of the worksheet C:Z contains numbers which match a value column A. These numbers can be in any cell within this range C:Z. I would like to loop through all the values in column A until I reach an empty cell. For each value in column A I want to search(find) columns C:Z for the matching number and the replace the contents of the cell in D:Z with the concatenated value of columns A and B(seperated by a dash-). Here's some sample data and my expected result. A1=1 A2=2 A3=3 B1=abc B2=def B3= ghi C13=2 F29=1 M3=3 After the process: C13=2-def F29=1-abc M3=3-ghi Thanks to anyone who could help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |