BM409-16 Text Manipulation Cases 2011-10-19

BM409-16 Text Manipulation Cases 2011-10-19 - Goes to the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
1. Assignments for Text Manipulation 1A. Using an IF statement, fix the above data to have two digits in the first two columns Separate Get the check for Write an Put them Put them into Put them left 2 Value error IF to Pick up Pick up Pick up all together a text value into an characters using using add a the right the left the right so they that Excel Excel date using zero seven using three using four using are correct recognizes, i.e., using Dates: LEFT VALUE ISERR IF RIGHT MID RIGHT DD-MMM-YYYY DATEVALUE 1=true,0=false 20Dec2011 15Oct2009 1Mar2010 30Sep1967 15Jun1957 6Oct1975 14Dec2001 4Dec1958 13May1921 9Mar1972 31Jan1955 6Nov1953 27Jun1958 9Apr1943 5May1956 LEFT(cell,number of digits)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Goes to the cell, brings back the number of digits from the left) VALUE(cell) Brings back the value of the text in the cell ISERR(cell, if_true,If_false)) Checks the cell, if true does the action, if false, does the action IF(condition, if_true,if_false) Makes a condition, puts a 1 if true, 0 if false RIGHT(number of digits) Brings back the number of digits from the right MID(starting point, digits) Brings the text starting at the digit number for the number of RIGHT(number of digits) Brings back the num Use & to concatenate data Use & to concatenate data Datevalue(cell)...
View Full Document

This note was uploaded on 11/22/2011 for the course FINANCE BUS M 409 taught by Professor Bryansudweeks during the Fall '11 term at BYU.

Ask a homework question - tutors are online