Search results

No, this separates the string after @. I have done this part. I want to separate first name and last name?

I have strings such as below: Anthoney-Barcelona@gmail.com Austin.mark@cox.net Tony Brian@sbcglobal.com I have taken off the string from @on. I only have the string before @. How can I do it? Thanks, GN

I have a column with values of: 4 5 6 7 I have filtered on this column and I have selected only 4 and 6. Go to Edit Select only visible cells copied 4 and 6 selected the first cell of a column where I want to paste the value and did CTRL + V 6 is getting pasted in the adjacent In front of 5...

Thank you very much for your great help. GN

If the the total of two cells in M5 and M6 equals to the value of M10, then M10 should be filled in red. How can I manage this in conditional formatting? Thanks, GN

Hello Hui, I need a template that we enter item #, items on hand, inventory turnover, then it gives us a reorder point for the item. Regards, GN0001

I have uploaded the same file one more time to be sure.

Yes, I have uploaded what you had sent me. I hope you can download the file. Thanks, GN0001

Hello team, I am looking for a financial modeling, I don't know what it is called. It might be called financial modeling in Excel. I need to enter the item, the inventory turn over, and the number of items available in hand to find out the order point for that item. (Do we need to involve the...

Hello team, This didn't work me and I had to redo my project since some of these were pasted wrong. If the range is right under the filter, it would work, otherwise, it wouldn't work. regards, GGGGG

It doesn't work, unless my filter to be turned on the first row. I cannot send you the screen shot.... But my filter is turned on only on one of the columns and filter is placed on the second row, not on the first row. Hope this is clear. GGGGG

Hello all, I still have problem with copy and pasting the some cells that are not in a row. I apply all the instruction, but still it doesn't work. Any help/ GGGGG

Hello Team, Thank you for all your generous help: I myself have taken care of the case with the IFERROR: (IFERROR(IF(FIND(",",C13)>0,(LEN(C13)-LEN(SUBSTITUTE(C13,",",""))+1),""),"")) But I think the second and third version solutions are better solutions. Also, in response to SirJB7...

SirJB7 I should thank you more. GGGGG

I want an if statement/ function which states find "," in a text, if there is one, then find how many of them are repeated in the cell. If there is no "," in the cell, bring back no value (""). IF(FIND(",",$B9)<>0,(LEN($B9)-LEN(SUBSTITUTE($B9,",","")),"")) This doesn't work, when...

thanks for the help. GGGGG

Hello, Thank you for the response. Do we have a built in function in Excel for this purpose? Regards, GGGGG

Hello, Does anybody know how to count the occurrence of a specific character in a cell? I have a cell contains: 123, 2224,555 I need to put a function that counts the number of "," in a cell? Regards, GN

Hello Shrivallabha, what you say didn't work. I used clear format and it took all the apostrophe sign out. But this solution may not work for all the cases. Thank you for the help and your time. GGGGG

Hello Shrivallabha, I did this, but it didn't work. I went to clear format, the apostrophe was taken away. However one solution doesn't work in all scenarios. Regards, GGGGG

Hello Narayank991, What you said on the top help me a lot with my work tasks.Thanks a lot. How can we convert the date which is entered as string to date(Number)? GGGGG

Yes, I did, it didn't work. However I found the answer. =TRIM(SUBSTITUTE(A1, CHAR(160), " ")) But I am looking for easier solution, because each column of the worksheet has ' sign. I have to go to each column one by one to remove this character. It is time consuming. Do you have any other...

Data has come to me as: '00001234 and contact name as 'John. I need to remove the apostrophe or ' from the beginning of my text. I tried Right, Len, code and substitute, clean, trim function and they didn't work. I formatted the column as a text.... any help? GGGGG

Where should I download the file? Also, - I need to convert the data to text and then use code function to know what the char number for invisible characters in the text are and then use the result of code function into substitute function to replace the char with "" or no space to clean the...

Hello Narayank, I am confused. I have two spreadsheets, I put type function on date column, first sheet returns 1 and the other one returns 2. I need both to be the same, both date or both string or both numbers? How can I convert the date shows type 1 to string? Thanks for the help. Guity