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
I am attempting to link multiple cells I have in sheet 1 to multiple cells with text in sheet two. I would like to have a text box in sheet 1 display the information in sheet 2.
can you please help me?
Solved by D. L. in 25 mins
I'm doing a spreadsheet of important things and I want to have the 2nd column of text move into the 1st if I deleted the text in the 1st column
Solved by E. H. in 22 mins
Stuck with a VLOOKUP issue in Excel. Have tried everything from looking up numbers to text, text to columns, copied data into a new sheet, pasted values only, text to columns, lookup values as text and nothing works. I am not new to troubleshooting VLOOKUP issues but this has me stumped.
Solved by D. J. in 20 mins
Vlookup issue. I have tried everything to lookup the USD prices in the GEN TRUCK tab from the BIS tab sheet.
I have changed the formats from numbers to text by using text to columns in both sheets. I have changed to numbers by multiplying the data *1.
Solved by A. H. in 17 mins
If the range of cells present in a text, I want the name that is present, for example I have a list of user names, if their name is present in the paragraph, I want that name to be extracted
Solved by C. D. in 14 mins
i have run out of credit, hope this time helped me. Excel data validation formula to restrict user input for: 1. any space in the text. 2. repeated letter or number in text.(restric aABCD, A and a is same) 3. text length must between 5-10
Solved by M. A. in 30 mins
data validation to restrict user input of transaction code, restrict: 1.repetition on character i.e. letter, symbol, number, marks. (example UA2#5T#, # is repeated). 2. any space 3. text longer than 10
Solved by S. A. in 22 mins
please help me only if you can do data validation formula, without macro if possible. user input in transaction code column are excel restricted values:
1. restrict repeated character ie letter, symbol, marks, number
2. restric space
3. restrict text length more than 10
Solved by K. H. in 21 mins
Is there a formula to delete text from a cell when a date passes in an adjacent cell?
Solved by X. B. in 15 mins
how to change rows color based on text, for example when I type in "service" it changes the whole row to red. but when I type SOLD it changes the row to yellow
Solved by D. H. in 28 mins