Get instant live Excel expert help with Text Functions

I need to know how to use text to column option in excel

I need to learn text to column option in excel

Let me know what is the error in below formula =VLOOKUP(CONCATENATE(TEXT(A3; "dd-mmm-åååå");" "; B3);'Daily Overall Snap'!(CONCATENATE(TEXT($A; "dd-mmm-åååå");" ";$B)):$Q;3;FALSE)

I have a problem in text to column option in excel

Hey - I'm working on a forecast in Excel 2013 and need to format it using font colors. I'm looking to make a macro that turns the font colors blue if you hard-code a number, green if you link from another spreadsheet, and black if it's a formula within a spreadsheet. Is this possible and, if so, how would I go about it? Thanks! Also, I'd like to avoid changing the color of any text.

I would like to insert a formula which counts the number of filled rows (Number or text) beside column A in each cell of column of A for each row. For example. Cell A4 should count the number of filled cells beside from B4:BP4. Cell A5 should count the number of filled cells beside from B5:BP5. The cell in column A should stay blank if there is nothing to count

combining text in column - first name in one column and last in another to one column. I have used a formula to do this which was pretty cool however when I delete the original columns the combined name goes away and #REF is left. Is there a way around this?

Hi, I am trying to combine 2 AND formulas so that I can sa if an error. I need to be in this example to highlight one of two things:- If the box "Y" for sign up, and there is a value in A2, text saying no error If the box is "N", and there is no value in A2, text saying no error Anything else (i.e ticked yes but no data before, or ticked no but data before), text saying error

Hello, I am writing to you because I am having problems with a macro I created (with help of some online forums). I want the macro to delete all rows that on column AE have the text "Duplicate". In addition, I would also want that before running the macro, a pop up appears asking "do you really want to delete duplicates?". Finally, one more thing that I would like the macro to do is show in a message box the number of rows that have been deleted. You can find the macro below I would GREATLY appreciate your help, Xabier This is the macro I have written: Sub delete_duplicates() 'ask if really want to delete' On Error GoTo Err_btnDeleteRecord_Click Dim Answer As Integer Answer = MsgBox("Are you sure you wish to delete duplicates?", vbYesNo + vbExclamation + vbDefaultButton2, "Delete Confirmation") If Answer = vbYes Then 'direct where' With ThisWorkbook.Sheet4 'remove filters' .AutoFilterMode = False 'filter rows that on column AE have text "duplicate"' With Range("AE1", Range("AE" & Rows.Count).End(xlUp)) .AutoFilter 1, "Duplicate" On Error Resume Next 'delete these rows' .Offset(1).SpecialCells(12).EntireRow.Delete End With 'remove filter' .AutoFilterMode = False MsgBox 'Number of deletions' & = 57241 - (rowCount = Application.WorksheetFunction.CountA(Range(“AE2:AE57241”)) End Sub

value ### showing up on every line with text