this is a test1 - 12345
this is a test2 - 12456
this is a test3 - 11234
this is a test4 - 13789
I need to extract the last 5 digits of each row which will be the 5 digit number and put in column B for some data manipulation. How can I do this in excel? is there a forumula you can provide for this?
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …