text function

I have a lookup table where the lookup column is a combination of letters & numbers. I created an VLOOKUP formula that looked at the first column as all "text" values. A portion of the lookup table was as follows: AA AB 2 97013T 122320 3 #97015T 122266 4...

Hello All, I have the following cells in my excel sheet: I would like to extract the "Unit Number" from the Legal Description and then combine the whole address in one cell. End product should look like this: The main issue i'm having is extracting the Unit Number from the Legal...

I am trying to get a formula to display a currency total using the text() function and the concatenate() function but it drops the trailing zero. Here is the formula that I am using now: =IF(H14>I14,CONCATENATE("Over by: ",TEXT(H14-I14,"$#,###.##")),CONCATENATE(TEXT(I14-H14,"$#,###.##")," was...

I have dates on a sheet January 5, 2015 the cell is formatted as a date I want to convert it to text but keep the words not have it go to 42009. I need to upload this data to a different system that needs the long date but has to be text. Can someone help. I've tried all I can think of on this.

Hi, If in the column A I have: <tbody> Column A ColumnB A1: First Name: Audi Audi A2: Title of Book: Eliza Eliza A3: Last Source: Data_v3 Data_v3 </tbody> how to write function, that will be inserting into column B, text afer " : " ?

I want to store a number as text, formatted to 4 decimal places. Doing this within the spreadsheet, you can do: =text(value, "0.0000") How can I accomplish the same thing in VBA? I'd rather just have the result and not a result with a formula in the cell. Thanks

I am trying to convert hundreds of names from a full name to the last name plus first initial. IE: John D. Doe to doej Here are some examples: Some have middle initials and some don't George T. Jones = jonesg John D. Doe = doej Alan Johnson = johnsona Roger Doe = doer

I'm writing some code where I take the value below the active cell and concatinate the Month-Year. I recorded this method: ActiveCell.FormulaR1C1 = _ "=R[-4]C&"" ""&TEXT(R[-8]C[4]&""-""&R[-9]C[4],""mmm-yyyy"")" And then tried to add in the variables (which I have confirmed do work...

As what it says in the subject. I tried writing this in sheet1 A1: =text('sheet2'!E24, "@") It appears the value as in E24 but i cannot format cell the value to accounting and put the demical value to 2. it still appears like this: 2345.54332 Is there anything other than TEXT function