Hello, first of all thank you for the video, it was really helpful. I am dealing with a similar situation however my part numbers are not just separated by a hyphen. what if the part number is either split up with multiple characters. Sometimes it will be a letter, number, or special character. Is there a way to use the FIND function but have it look for multiple characters? For instance have it first search for a hyphen and if it does not find a hyphen to look for the next possible character.
I don't think this would be an issue. Ask in our forum and put some sample values in the question, or a sample file with values, and it will be easy to help :) www.teachexcel.com/talk/microsoft-office?src=yt_comment
Hi, Thanks for the video. I am looking for a solution which can help me to extract specific word from a string present in one cell and replace the same with different word from another cell. How to do it ?
I'm trying to get only the first word after a certain character (ie,#) but I can't seem to. I'm using MID(A1,SEARCH("#",A1)+1,SEARCH(" ",A1)-SEARCH("#",A1)-1) Anyone know what I'm doing wrong?
Sorry for the late reply, there are a lot of comments to go through, ask this question in our forum on TeachExcel.com and you will be able to get help - if you have a sample file you can also upload that and it makes it easier to help.
@@TeachExcel I liked how you broke the concept down to bite size chunks in a logical progression. I wish some of our company's so called trainers could explain these things as well as you do.
Not sure what you mean. Ask the question in the forum on TeachExcel and it will be easier to respond (there are so many comments on here that it's difficult to be able to come back and see your reply) www.teachexcel.com/talk/microsoft-office?src=yt
Hello, first of all thank you for the video, it was really helpful. I am dealing with a similar situation however my part numbers are not just separated by a hyphen. what if the part number is either split up with multiple characters. Sometimes it will be a letter, number, or special character. Is there a way to use the FIND function but have it look for multiple characters? For instance have it first search for a hyphen and if it does not find a hyphen to look for the next possible character.
I don't think this would be an issue. Ask in our forum and put some sample values in the question, or a sample file with values, and it will be easy to help :)
www.teachexcel.com/talk/microsoft-office?src=yt_comment
Thank you, very well explained.
Hi, Thanks for the video. I am looking for a solution which can help me to extract specific word from a string present in one cell and replace the same with different word from another cell. How to do it ?
Hi.. thanks for the video. Love that nested FIND for locating the second or third instance of a character in a string! Thanks for sharing. Thumbs up!
Definitely, I love FIND for small examples, and I'm sure you are already familiar with SUBSTITUTE(), which is great for the more complex ones.
What about extracting the entire date from a cell in the format 28-06-20
I'm trying to get only the first word after a certain character (ie,#) but I can't seem to.
I'm using MID(A1,SEARCH("#",A1)+1,SEARCH(" ",A1)-SEARCH("#",A1)-1)
Anyone know what I'm doing wrong?
Sorry for the late reply, there are a lot of comments to go through, ask this question in our forum on TeachExcel.com and you will be able to get help - if you have a sample file you can also upload that and it makes it easier to help.
A very complicated concept, well explained in a concise manner.
Thank you! I'm glad you think so)
@@TeachExcel I liked how you broke the concept down to bite size chunks in a logical progression.
I wish some of our company's so called trainers could explain these things as well as you do.
THANK YOU VERY MUCH
Excellent Tutorial Really Helpful Especially for Students Taking the MOS Excel Exam Thank You Sir :):):)
Very glad to help)
Your content does not match your number of subscribers. I've excel youtubers your content is the best by far.
Thank you so much! This means a lot to hear :)))) You can help by sharing my channel with your friends ;)
How can you preview formulas?
Not sure what you mean. Ask the question in the forum on TeachExcel and it will be easier to respond (there are so many comments on here that it's difficult to be able to come back and see your reply) www.teachexcel.com/talk/microsoft-office?src=yt
How to add headings from 1st page to remaining pages in printing sir please explain
Search for printing tutorials on teachexcel and you should find an answer or ask in our forum)