Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a need to reduce the amount of text in a range of cells. There are
certain keywords that are not necessay in the cells that if removed the text length would be acceptable. How do I go about removing keywords from cell text with VBA? This would need to run in column G of my worksheet. Here is an example: (keywords are "Q Line" & "120 VAC") Befo Q Line THQB 120 VAC 1 pole 20A After: THQB 1 pole 20A Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
extracting text between two keywords | Excel Worksheet Functions | |||
extracting text between two keywords | Excel Worksheet Functions | |||
extracting text between two keywords | Excel Worksheet Functions | |||
Finding keywords in several text columns | Excel Discussion (Misc queries) | |||
How do I search for keywords in cells containing text? | Excel Worksheet Functions |