| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND SPECIFIC TEXT AND REPLACE IT
I need to find the word "Void" in one column of data and if it is there (and
it would be in ALL CAPS), then the return needs to be V; if it's not there, the return needs to be I. Plus, would it be possible for the V or the I to replace the original data? I've tried the if function, but I'm not putting in the right criteria obviously... The data is imported from QuickBooks into Excel and contains the check MEMO field. I am trying to find Voided Checks for a daily batch report to send to our bank. This is the only way I've found to capture that data at this point, but I need the column to have only either V or I... Any help would be greatly appreciated! Thanks so much, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace can't find text | Excel Discussion (Misc queries) | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| Find & Replace in Text Box | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| Find/Replace Text In Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
