I'm wondering if someone can come up with a formula solution for the following:

I have a table where I import my bank transactions. I want to use formulas in an adjacent column to check for keywords (which are located in a separate table) in those transactions and then replace them with those keywords (so I can then further act on those result by categorising them etc.).

For example, a transaction to Amazon might look like this: Amazon Marketplace 0065468, or like this: Amazon Mktplc 0066 etc. The keyword here is obviously Amazon. I have a separate table with 2 columns: Column 1 is the keyword to find, column 2 is the value to replace that keyword with. They are identical: I want Excel to check if the entire text string imported by the bank has the word Amazon, and if it does then replace it in the next column with the word Amazon.

The key problem here is obviously that I need the formula to check 1 text string against multiple keywords. I've tried many combinations of Index, Search and Substitute formulas but none seem to work.

I should note that I have achieved this result with a very long IFS formula, where for each keyword I add another ISNUMBER(SEARCH("Keyword", "Replace with keyword")) part to the formula, but this means I have to manually keep editing the never ending formula for each new keyword. As above, I am looking for a more efficient and streamlined way of doing this by way of a lookup table with the keywords.

I attach here a sample …

From vba in Microsoft Access, how can I open a form saved in a word .docm document and set a textbox on the form to a value?

So far I have:

    Dim objwrd As New Word.Application
    Dim doc As Word.Document
   
    Set objwrd = CreateObject("Word.Application")
    objwrd.Visible = True
    Set doc = objwrd.Documents.Open(FileName:="C:\Users\db1\Documents\Test.docm", Visible:=True)

I know if I'm running code contained in the Word document I can do something like this

Dim frm As New UserForm1
frm.Show

But this code is automation code running in Microsoft Access and I don't see a forms collection in the Document object.

I notice in Office 365 online, that if you have a word document open, you can switch to desktop easily.  However, is this possible the other way?  While I have the desktop Word app open, can I switch to viewing it in the web browser from the app?

Hi there is a Word document in which there are a lot words highlighted with yellow or other color. Do we have a way to pick all of them up with one action or two and to move them to another location in the document? Thank you

Hello,

How can you paste a list of hyperlinks from a spreadsheet or table into a Word document and lose the table but retain the hyperlinks?

For example, suppose you have a list of 5 hyperlinks in Excel. How can you paste that list into Word so that the links still function (as links) but are in a simple list rather than a table?

I see several paste options which remove the table but they also remove formatting (including the hyperlink function) and simply leave you with the text.

Thanks

I create a text box in word.  I insert the page number.   I then copy that text box, complete with the page number, to a new page.  The new page shows the old page number, not the new one.  How can I create a text box with a variable page number that will show the page number whereever I copy/paste that text box?

Most of the 'mistakes" i make in spelling in Word ae just typos.

RAther than having Word show me that I made a typo, and asking me to go back and correct each one, is there any way to turn on auto-corect and have it uder-line the words it FIXED.  So that I can say, "Yep!  THats right!"  And I just carry on with my work.

Thanks!

OT

When opening any Office 365 application all I see is a white screen.  Program is there as I can approximate where the X is and close the program.  Tried repairing and uninstalling and reinstalling.  No use.  
I recently upgraded from WIN7 to WIN10 and had some display issues when opening Word documents. I was able to use Office for a few weeks but had random display issues with Office files (Word, Excel, etc.)   Tried repairing and reinstalling -  
Narrowed issue down to not being able to see images in the documents.  Made a few changes in Display section in Word.  Now all I get is a white screen.  I see the menu bars at all.

Is there a way to have Word, Excel show the directory at the top of the page so that I know where the document is stored on the computer using Windows 10? Thanks

Hi,

My boss bought a Chromebook for his son and asked me to set it up. I thought it was going to be a breeze. But..........

I created a gmail account for his son and then installed Word (he bought a license yesterday.) When Word opens, I enter MS account info. As EEs can see, it shows OneDrive is connected, but on the top right corner still shows "sign in".

Once I click on top right "sign in" and enter email, I got this "cannot add another OneDrive account"

Any ideas? thanks

Do you have the steps in creating a Return Address Label in Word 2013?
For example, the Return address name is
John Smith
1234 Bayside drive
Jupiter, NO 44444

How would I set this up? the label code is #8167

Hi Experts,

I have a list of required fields, and trying to construct a SQL statement out of it as follows.

ListOfFields.

[input#InsertRecordVisit_Date.cbFormTextField, input#InsertRecordClient_Last_Name.cbFormTextField, input#InsertRecordClient_First_Name.cbFormTextField, input#InsertRecordDate_Of_Birth.cbFormTextField, select#InsertRecordShift_From_Hour.cbFormSelect, select#InsertRecordShift_From_Minute.cbFormSelect, select#InsertRecordShift_From_AMPM.cbFormSelect, select#InsertRecordShift_To_Hour.cbFormSelect, select#InsertRecordShift_To_Minute.cbFormSelect, select#InsertRecordShift_To_AMPM.cbFormSelect, textarea#InsertRecordPurpose_Of_Visit_Goal.cbFormTextArea, input#InsertRecordTemp.cbFormTextField, input#InsertRecordPulse.cbFormTextField, input#InsertRecordRR.cbFormTextField, input#InsertRecordBP.cbFormTextField, input#InsertRecordO2_Saturation.cbFormTextField, input#InsertRecordO2_In_Use0, input#InsertRecordO2_In_Use1, input#InsertRecordRespiratory_Lung_Sounds.cbFormTextField, input#InsertRecordRespiratory_Breathing_Pattern.cbFormTextField, input#InsertRecordBipap0, input#InsertRecordBipap1, input#InsertRecordCpap0, input#InsertRecordCpap1, input#InsertRecordTrach0, input#InsertRecordTrach1, input#InsertRecordVent0, input#InsertRecordVent1, input#InsertRecordCardiovascular_Skin_Color.cbFormTextField, input#InsertRecordSkin_Temp.cbFormTextField, select#InsertRecordCardiovascular_Edema.cbFormSelect, input#InsertRecordNeuro_Alert0, 

Select all Open in new window

…