Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Find specific word in excel Results

Hi,

Is there any way to find specific word in excel . I have column containing university names and some of the records have abbreviations which I need to convert in full text.

For example, I want to find UDW (stands for University of Durban-Westville, but when I find UDW it gives me results like:

Albert-Ludwigs-University Freiburg etc.....

I have attached some records for your convenience. Please do not propose to apply filter as there are 296K rows and i did not have good experience of using filter in such amount of data.

Thanks in advance!

Hi
I would like to have an Excel macro that would find all the cells for the word "Sen" between column B to column D (my data has about 1000 rows), and then highlight the row(s) that contain the word "Sen".

Would you please help?

Thanks!

Hi,
I am trying to split cells based on the word in the single column... for example

start-123 data kumar policy none
start-124 data test for myself policy available
start-12 data testing john policy not used

this one to be split into new column when it finds words start, data and policy. Can this be done in excel?

Hi Guys,
I have read many of the threads searching for assistance on this one but none quiet hit the mark. I working on measurements, and I'm trying to find Specific
word(s) Within entire contents in the cell in specific column, if founded then copy entire row to another sheet.
I found old thread with this case (it solves only part of my problem), but I having problem to update by my way.

Thanks for any help.

Example:

Column A Column B Column C Ship Delay Issue Category RCA Category N Others Process Issue N Hardware Assigned to CFAAS PDT to update EC section in FS Y Others Assigned to CFAAS PDT to update EC section in FS N Label Priority Change Request Y Others Assigned to CFAAS PDT to change BOM Y Others Assigned to CFAAS PDT to re-approve FS Y Others Assigned to CFAAS Geo Team

Condition: Find all cells in column C containing "Assigned to CFAAS PDT" and copy entire row to another sheet.

Old thread
http://excel.bigresource.com/Track/excel-SjyKD0sG/


	VB:
	
 Search_and_Move() 
    Dim sTemp As String 
    sTemp = Sheet1.Range("A1").Text 
    If InStr(1, sTemp, "A", vbTextCompare) Then Range("A1").EntireRow.Copy _ 
    Destination:=Sheet2.Range("A1") 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I am frequently emailed files which are csv files. I can open them in MS
Excel 2003 fine. I always save these files on disk from the email (save
attachments). Therefore, the files save as .csv files. Windows (XP) file
search will not find specific words unless I open EVERY file in Excel, then
save it as a worksheet. This would take far too long.

Can someone tell me how to search for a specific word in the various files
in the directory? Alternatively, can someone tell me how to convert a large
number of files from .csv to .xls without opening each one and using "Save
As"?

Thanks

Hi,

I have a worksheet that contains 2 columns of data. I have listed a sample of the data as below column A and column B

...............Column A......................................Column B
Row 1......blacktalldog.com..........................black tall dog
Row 2......blackhungrymouse.com................black hungry mouse
Row 3......thebigshortdog.net........................the big short dog
Row 4......bigblacktable.net..........................big black table
Row 5......bigtalltree.net...............................big tall tree

I have some questions on how to do the things I want.

1) I want to excel to search the whole document and detect rows with cells that start with the word 'black' and cells that start with the word 'big'. Delete the whole rows.

results to return will be
Row 3......thebigshortdog.net........................the big short dog

2) I want to search Column A only, delete the rows if the cells in Column A ends with '.net'

results to return will be
Row 1......blacktalldog.com..........................black tall dog
Row 2......blackhungrymouse.com................black hungry mouse

3) I want to detect cells that contain the word tall. If the word tall is detected in Column A or Column B, delete the row.

results to return will be
Row 2......blackhungrymouse.com................black hungry mouse
Row 3......thebigshortdog.net........................the big short dog
Row 4......bigblacktable.net..........................big black table

Thanks

I am frequently emailed files which are csv files. I can open them in MS
Excel 2003 fine. I always save these files on disk from the email (save
attachments). Therefore, the files save as .csv files. Windows (XP) file
search will not find specific words unless I open EVERY file in Excel, then
save it as a worksheet. This would take far too long.

Can someone tell me how to search for a specific word in the various files
in the directory? Alternatively, can someone tell me how to convert a large
number of files from .csv to .xls without opening each one and using "Save
As"?

Thanks

Hi All,

I have a following requirement.
I want to search for three words in a string, if any of the keywords is found first in the string, then that keyword should be placed in the cell left of the cell in which string is there.

For example:
Cell B1 contains "System PR1 is connected to PC1 with an interface at PB1."
No I want to search for any of the following keywords:
PR1 or PC1 or PB1.
Since it will find PR1 first in the string, so in cell A1, it should return PR1, and should omit searching remaining keywords, since it has found the first keyword that I am looking for.

Let us suppose if PR1 is not in the string then it should return PC1 in the cell A1 since it is a second keyword I am looking for in the string if available, if PC1 is also not in the string, then it should search for PB1 in the string and if it finds PB1 in the string then it should return PB1 in the cell A1.

If none of the keywords are part of the string, then it should return whatever I want to return like "Null" or "Not Found".

I tried the Find command but it is not working in the above scenario, and does not start finding for the second keyword if the first keyword is not found.

Any help would be of great help for omitting the manual work I am performing in Excel.

Thank You,
Saurabh.

Hi All,
I just registered couple of hours ago and this is my first post.

My Column A contains person's name and a title of that person

Example:
Column A
(Cell 1) Abraham John Mr.
(Cell 2) Jones Patricia Mrs.
(Cell 3) Baldwin Gloria Ms.
(Cell 4) Thomas Reggie

In Column B I want a formula which would search for Mr. Mrs. and Ms. and If it finds any of the three words, then it should return as true or it should return false.

I know this can be done using the find command but I am not able to nest it properly and use it to find all the three words in 1 cell.

So the output for the first 3 cells of Column A would be True and for Cell 4 would be false.

Hope I am not confusing you guys and it makes some sense.

Any help in this regard would be much appreciated Guys!!

Thanks in Advance!!

Have a Great Day!!

Regards,
Gopal.

I am attempting to calculate a number of specific word occurrences. In
example, I have a column with yes in certain cells, and no in the others.
How can I display the total number of yes and no occurrences? I am fairly
new to Excel and know very little about coding in it.

Hello,
I have a Word document that I need to search for a specific word, copy the entire sentence, and then paste into the next available row in excel. Is there a way to do this using Macros? I don't have much experience setting up the Macros, beyond, "record".

Any help would be appreciated.

Thanks.

Hello,
I think this is a pertinent question because I can't find a solution anywhere. Please advise if you can shed light on the matter.

In Word, I select text, then assign it to a variable, then click a macro button that that sends to a specific Excel file. Excel places the data from Word in the last non-occupied cell in a column. I will then close that Word doc, open another Word doc, select something, repeat the process of sending data to the Excel file, but wish to do all this without closing the Excel file.

The Word sub checks if the specific Excel file is open, if not, it opens the file. That's good if the Excel file is closed. However, on the second go around--with the open Excel file, the Word sub does not recognize the Excel object. The second Word document to send to Excel doesn't acknowledge the existing instance of Excel. I inserted a face (below) to show where the second iteration of the send-to-excel action gets hung up. I 'think' that because the Excel object naming happens in the IF statement area---which the second iteration bypasses---Word can't find the Excel object.

[[This inquiry perhaps addresses a larger issue (for me) of how to 'loop' between Word and Excel, without closing the child (Excel) document.]]

Any feedback is much appreciated---Patrick

Sub send_variables22()
Dim XLApp As Object
Dim XLSheet As Object
Dim wBook As String
Dim Target As Integer
Dim r As Integer, Hits As Integer, LastRow As Integer
Dim ColB As Variant, ColD As Variant, ColI As Variant

'''invoke the counter function---not copied here.
Dim strWbkName As String
strWbkName = "label_holder.xls"
'set your workbook name

If IsWorkbookOpen(strWbkName) = False Then
'call the Function To test If it Is Open
'MsgBox "The workbook " & strWbkName & " is not open!"
'Exit Sub

'''open doc if nothing is open
wBook = "C:Documents and SettingsAdministratorDesktoperjValidationlabel_holder.xls"
Set XLApp = CreateObject("Excel.Application")
Set XLSheet = XLApp.Workbooks.Open(wBook)
XLSheet.Application.Visible = True
XLSheet.Application.WindowState = xlMaximized
End If

lngusedrange = ActiveSheet.UsedRange.Rows.Count

With XLSheet.ActiveSheet
.Range("start_here").Select
.Range("start_here").Offset(lngusedrange, 0).Value = a
.Range("start_here").Offset(lngusedrange, 1).Value = b
.Range("start_here").Offset(lngusedrange, 2).Value = c
.Range("start_here").Offset(lngusedrange, 3).Value = d
.Range("start_here").Offset(lngusedrange, 4).Value = e
.Range("start_here").Offset(lngusedrange, 5).Value = f
.Range("start_here").Offset(lngusedrange, 6).Value = g
.Range("start_here").Offset(lngusedrange, 7).Value = h
.Range("start_here").Offset(lngusedrange, 8).Value = i
.Range("start_here").Offset(lngusedrange, 9).Value = j
.Range("start_here").Offset(lngusedrange, 10).Value = k
.Range("start_here").Offset(lngusedrange, 11).Value = l

'Set a = Nothing

End With

XLApp.Quit
Set XLApp = Nothing
Set XLSheet = Nothing
End Sub

I am trying to seperate some text that currently lies within one column. I know how to seperate the text into colums based on the spaces between them but this is much more complex and we have to do 300,000 of them.
Here is the example:

Column text is "Danburry South High School". I need to seperate the "Danburry South into one column and "High school" into another.

I need the script to do a find "High School" and then seperate everything before into 1 column and everything after into another.

Here are some samples from the list

LINCOLN MIDDLE SCHOOLFREEDOM MIDDLE SCHOOLWATERTOWN HIGH SCHOOLSONOMA STATE UNIVERSITYCREEKSIDE INTERMEDIATEHARVEST CHRISTIAN HIGH SCHOOLRACELAND JUNIOR HIGH SCHOOLAURELIA HIGH SCHOOL

In my script for run 1, I would want to say use "middle school" as the seperator, so end result would be this as the finished columns

LINCOLNMIDDLE SCHOOLFREEDOM MIDDLE SCHOOLWATERTOWN HIGH SCHOOLSONOMA STATE UNIVERSITYCREEKSIDE INTERMEDIATEHARVEST CHRISTIAN HIGH SCHOOLRACELAND JUNIOR HIGH SCHOOLAURELIA HIGH SCHOOL

Run 2, changing keywords to "High School"
end result would now be

LINCOLNMIDDLE SCHOOLFREEDOM MIDDLE SCHOOLWATERTOWNHIGH SCHOOLSONOMA STATE UNIVERSITYCREEKSIDE INTERMEDIATEHARVEST CHRISTIANHIGH SCHOOLRACELAND JUNIORHIGH SCHOOLAURELIA HIGH SCHOOL

I would appreciate any help on this! Thanks
FYI, I am using Excel 2007

Assistance greatly appreciated!

Building code in a macro to do the following:

1) Find a specific figure on Sheet 1 & assign to variable.
2) Go to Sheet 2, Unprotect
3) On Sheet 2, find first empty row in a specific range (B8,B97)
4) Put today's date in resulting 1st cell (IE B10)
5) Put a specific description (already defined in a variable) in next column (IE C10)
6) Run calculations on figure previously collected from Sheet 1 and put results in next column (IE D10)
7) Re-protect sheet
8) Repeat with different data on 35 additional sheets.

The key to all of this is locating the empty row on each subsequent sheet and then knowing how to reference each cell in that row in my programming so I can accurately assign the proper data. This is the only part I've yet to figure out in this project. In other words: Find an empty row in my specific range, then assign unique data to 3 specific cells in that row.

I know this would be extremely simple for even a moderately strong user of Excel & VB, but, alas, I am not that person. Any help would be greatly appreciated!

Hi everybody!

I am battling to figure these things out:

I want a user to be prompted to type data into a display box (or whatever those pup-up things are called) as soon as a specific macro is run.

These values must then be checked (I think validated?) and error messages must be displayed if numbers are typed in a name box, letters in a number box, and space bars before letters or punctuation marks.

As soon as the values have been completed, the macro must carry on running.

I know what I want, but have not a clue where to start finding the right words to look for the code!

Can someone please help!

An example is attached.

Regards

Harry

(p.s. The Watermark Macro that Roy has been helping me with is to be used here eventually. I am currently asking the user to type the values that I want to be collected in the manner above into specific cells in Excel. These values I want to use as Roy's Watermarks, but I am currently using them as footers. (Simply by "copying" the calues to the other spreadsheets (E15=Workshhet1$e$45, e.g.) I would, however, as soon as I can get the above problem solved, like to use these values as Watermarks. Maybe by getting the values directly from VBA or from the selected cells. I currently have no way to check the validity of the data typed into the cells, as I want to have.)

Cell in excel containing large amount of text. Contains the following text one or more times (including the speech marks):

"Provide Dwd/Dwl Number: DWD*****"

What I need to do is extract all of the DWD values from this cell, load into an array and dump them into another cell. It's the extraction bit that I need to sort out.

In my mind the way that the code should work is:

Find all instances of 'dwd'
For each instance of 'dwd'
check the next/proceding character.

if the character is a space, check the next one
if the character is not a number or space, break and go to the next instance of 'dwd'
if the character is a number add it and the next 5 characters to a temp variable (varTemp)
loop

take the value of varTemp, prepend it with 'dwd' and add it to the running list/array

Loop

Output the full list of DWDs
Any ideas?

Hello guys. I am a complete newb to VBA.

What I want to do is this:

I have 22 CSV files. I want to search each of those files for a specific text string (ie: "profile" or "description"). When the macro finds the word in any one of the CSV files I want it to copy that complete csv worksheet and paste it into an excel xls file.

Please tell me how I can go about doing this. Not also that while vlookup is possible, its very time consuming if i have to do this 50 times over and each time the csv files have different file names. that is why i want to search within a file (each file has its own unique identifying text string)

Hello,
I'm working on my PhD dissertation in linguistics, and I have a specific Excel problem that I'm sure there's an easy macro to solve, but I know nothing about them. Hopefully someone can help me out and literally save me months of work (and some well needed sanity!)

I have text from recorded interviews (in Spanish) in column A, one word in each column. What I need to do is find specific words, and then automatically insert text in adjacent columns (linguistic coding for a stats program) For example, say I need to find the word "gente" throughout the worksheet. I need to find it, and then place codes next to it. So I want all instances of "gente" to read:

gente E C N x o c n u Z

Where each of the code letters is in a different column. Ideally, the macro should do this for all instances of gente in the worksheet (maybe 100 or more).

I would GREATLY appreciate any help. And if you ever need Spanish/linguistics help, don't hesitate to ask :-)

BTW, gente=people
Thanks!
Jim

Hi, This is my first thread ...

I wrote a very simple Macro to do 'Subscripting' which I need in my work...
It keeps the 1st letter of a word as is & changes other letters to subscript up to a Space...
It is working fine in Excel 2010 but in 2007 it is giving a Runtime error.


	VB:
	
 SbScrpt() 
    Dim x As Object 
    For Each x In Selection 
        With x 
             
            .Characters(2, Application.Find(" ", ActiveCell, 1) - 1).Font.Subscript = True 
             
        End With 
    Next x 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Whats wrong in it ???

Hi there dear folks,

Is it possible to find out the middle character in a word which is written in a specific cell in excel.

I mean let's say, I wrote "MrExcel" in a cell and I want to discover the "x" with some formula..

any idea please?


No luck finding an answer? You could always try Google.