-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
string function
-
E
Performing a Vlookup in the data sheets having emp. names in reverse order seperated by comma using Vlookup, Mid and find function only
Hi everyone, <tbody> Can anybody tell me how to Map employee name from column C (in column B) matching exactly the "Resource name" given in column A Using only Vlookup, Mid and find functions. <tbody> </tbody> <tbody> <tbody> Resource Name </tbody> <tbody> Employee Name </tbody>...- ektab2
- Thread
- abhishek aditi mid function string function vlookup
- Replies: 1
- Forum: Excel Questions
-
L
Copy portion of cell involving date and time
Cell A1 contains the following: 6/6/2012 4:00:00 PM The formatting of Cell A1 is custom m/d/yy h:mm I would like to paste only the 4:00:00 PM portion of cell A1 into a new cell I understand generally the concept of string functions, but have not had much experience using them and can't seem...- lilmish
- Thread
- copy paste string function
- Replies: 3
- Forum: Excel Questions
-
B
IF statement involving string function
Hi, Please help or advise. I am trying to write an IF statement that allow me to autofilter my data list. My code is to use string function to detect a certain text in a cell (D3), so basically if D3 contains "77" then filter with a condition, else filter with another condition. Below is how my...- btyturtle
- Thread
- autofilter if then else string function
- Replies: 5
- Forum: Excel Questions
