Get instant live Excel expert help with Text Functions

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a list of staff initials a two week timetable and two locations (e.g.Locations identified by cell color or text color) how can i count/sum which staff member has chosen which locations by putting colored text in a session.
Solved by F. A. in 25 mins
I want to create a forumla that will recognise text in one cell, but then count the number in the cell next to it. is this possible?
Solved by D. J. in 20 mins
I want to match a single cell having text, with the data string in a single column and return the number of matched cells. eg GR46 in single cell GR46 GL50 GR46 Gx200F etc as a cloumn Match the Cell values and return the number of matched items. eg 2
Solved by T. J. in 26 mins
I have created a spreadsheet that has a drop down list at the top of the worksheet. The cells below will be populated based on what is selected in the drop down box. I have used vlookup formulas to populate the worksheet. I am now trying to hyperlink the populated data to other documents. But since the cells are filled with formula text and are changing dependent on what is selected in the drop down, I am unable to figure out how to hyperlink the cells. This spreadsheet will be used by many people for many different purposes, so the hyperlink needs to be automated. Do you know how to link cells based on the formula output?
Solved by K. H. in 14 mins
i have a userform called "frmupdatecase" which is opened by clicking on the button "update case" in sheet!invoices - main. when you select a name from the cbo box say "bridet" it displays the text in the fields. you can then edit this text and when the cmd button "update case details" is pressed the data is written to the cells in the sheet invoices main and the form automatically close. this is all great, however the next time you click on the button to open the form it has the last name already selected. i need it to be clear ready for the next name search and edit. if you open and close the form after a change it is clear which is really strange.
Solved by S. W. in 30 mins
Yesterday I had an issue with a spreadsheet and was kindly given the formula below =VLOOKUP(TEXT(TODAY(),"mmm"),$A$5:$H$16,8,0) This found latest value under current month. I am now trying to do something the other way around. I need to copy a value and place it in current month In summary A5:A16 are months Jan through to Dec B5:B16 are where the copied values are placed B21 is where latest value is entered Example if it is Month Sept, I need the value from B21 copied to month April, which is B13; similarly if it is month October, I need the value to go in B14. The figures in B21 will change each month, but the copied amount that went to B13 or B14 need to remain. Something on lines of =IF(MONTH(TODAY()),($B$21),"0") In English <if its the current month, grab the figure in Cell B21, if not do nothing> But there is an error in my logic Hope that makes sense Appreciate any help, Thanks
Solved by A. D. in 19 mins
Need to check if all exact text of E3:E16 is present in cell A3, if yes then we need the value from F3:F16 in B3
Solved by A. L. in 24 mins
i need help with user forms. I have a worksheet that has forms. if you got to sheet - "bccs invoice" you will see a selction box at the top "rnginvocie" described by child surname. when you select a child surname the sheet auto updates with the correct data. if you scroll down you will see update buttons to update the text automatically, when i click on each update button a user form appears. what i am trying to do is have the user form auto populated with the relevant text depending on the child surname selected at the top of the sheet. so basically i dont want the combo box where you have to search for the child name everytime in the user form. then when you click on update cmd button it changes the data.
Solved by C. W. in 16 mins
I have a list of codes in column A and their text counterpart in column B. Column C is random list of column A. I would like to create Column D to be: IF column C=A then D=B
Solved by V. F. in 30 mins
hello, On the Pivot chart Y Axis the Text Label is repeating twice. How to eliminate this issue.The text label should only show once
Solved by G. H. in 22 mins