Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete specific text in spreadsheet
I'm thinking this is pretty easy to do, I'm new with VBA so would like your
help. I have a huge spreadsheet that I download each day and in this spreadsheet is the phrase "Split Payment". I want to delele that text anyplace it appears in the spreadsheet. How would I accomplish this? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete specific text in spreadsheet
Sub Macro2()
Cells.Replace What:="Split Payment", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub -- Gary's Student "SITCFanTN" wrote: I'm thinking this is pretty easy to do, I'm new with VBA so would like your help. I have a huge spreadsheet that I download each day and in this spreadsheet is the phrase "Split Payment". I want to delele that text anyplace it appears in the spreadsheet. How would I accomplish this? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete specific text in spreadsheet
Further to Gary's post, you can use Excel's Find utility: Edit Find
Use the Replace feature except leave the "Replace with" window blank. Regards, Greg "SITCFanTN" wrote: I'm thinking this is pretty easy to do, I'm new with VBA so would like your help. I have a huge spreadsheet that I download each day and in this spreadsheet is the phrase "Split Payment". I want to delele that text anyplace it appears in the spreadsheet. How would I accomplish this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select cell containing specific text &return value from another ce | Excel Worksheet Functions | |||
Delete text while numbers remain intact | Excel Worksheet Functions | |||
Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
How to save an excel spreadsheet as a text file without added quot | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |