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!”
Here are some problems that our users have asked and received explanations on
Need am excel separate text thats in a cell so i can sum them
Solved by G. C. in 23 mins
Create a button.
this is often titled “command button” for PC’s and “button” for Macs.
Input the following code in the Visual Basic Editor:
Sub Button1_Click()
Range(“A1”).Value = “Aloha”
End Sub
If you are having issues entering the Visual Basic Editor, right click the button, choose “Assign macro,” then press “New” to enter the code.
Click on the button to see “Aloha” in cell A1.
This is the assignment, I have to record myself doing this. I am on mac and am having trouble using the visual basic editor. I am not sure if I am putting in the code correctly becasue there is highlighted text with an arrow
Solved by X. F. in 27 mins
I'm trying to move some text in a cell to another cell
Solved by A. C. in 17 mins
iferror with a existing vlookup function that results in a Invalid Staff ID text
Solved by S. C. in 15 mins
Downloaded data and copied it into excel but when I subtract two of the numbers I get a #VALUE! in the results. When I manually change the contents in the cell (to the same number) it works. I changed one of the columns using the text to data function and the column is ok but will not work on the other column unless I manually change the data. What do I do?
Solved by C. H. in 27 mins
I need to loop through records in a listobject table, if the value in column J is not text (IsText = False), then copy the value in J to column L.
Solved by F. H. in 12 mins
looking for a count formula to look at column A for a text match, then tally the number in column B for each instance
Solved by Z. Y. in 26 mins
I have a raw data sheet that lists dates, numbers, and text.
Example:
I need a formula that will calculate if text contains "apple"
and is >= 1/1/18 and <1/31/18
Solved by Z. H. in 28 mins
Need help with the "engineering tasks summary" page based on text in a column, if the cell is "graphics" needs to be added to the engineering tasks page under the "panel & manufacture", if the cell reads "strategy / other engineering"
i hope this makes sense
Solved by S. D. in 21 mins
On a risk log I have a string text which combines probably & impact - I now want to give each variable a number so it automatically updates each risk score
Solved by A. A. in 12 mins