| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace
Hello,
I have a list of items which stores in column A as listed below and I want to write a macro to find from each cell within this column if any cell contains "43" replace that cell with 43 and if any cell contains "AA" replace that cell with AA. How can I do this? Please help! Column A AA4350D AC4390A CS3024D 43AA30D BB4325X AZ204CS Thanks in advance for your help! Anna |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find & Replace
What is the order of importance for a cell like AA4350D?
Can't you use an IF statement instead of VBA? -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "anna" wrote: Hello, I have a list of items which stores in column A as listed below and I want to write a macro to find from each cell within this column if any cell contains "43" replace that cell with 43 and if any cell contains "AA" replace that cell with AA. How can I do this? Please help! Column A AA4350D AC4390A CS3024D 43AA30D BB4325X AZ204CS Thanks in advance for your help! Anna |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find & Replace
Record a macro when you select column A
Edit|Replace what: *43* with: 43 replace all Edit|Replace what: *AA* with: AA replace all anna wrote: Hello, I have a list of items which stores in column A as listed below and I want to write a macro to find from each cell within this column if any cell contains "43" replace that cell with 43 and if any cell contains "AA" replace that cell with AA. How can I do this? Please help! Column A AA4350D AC4390A CS3024D 43AA30D BB4325X AZ204CS Thanks in advance for your help! Anna -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find & Replace
Hello Dave,
I tried to record a macro and it work perfectly. Thank you! Anna --------------------------------------------------- "Dave Peterson" wrote: Record a macro when you select column A Edit|Replace what: *43* with: 43 replace all Edit|Replace what: *AA* with: AA replace all anna wrote: Hello, I have a list of items which stores in column A as listed below and I want to write a macro to find from each cell within this column if any cell contains "43" replace that cell with 43 and if any cell contains "AA" replace that cell with AA. How can I do this? Please help! Column A AA4350D AC4390A CS3024D 43AA30D BB4325X AZ204CS Thanks in advance for your help! Anna -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| Find/Replace Event or Find/Replace for Protected Sheet ... | Excel Programming | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Using Find and Replace to replace " in a macro | Excel Programming | |||
| Replace method - cannot find any data to replace | Excel Programming | |||
Linear Mode
