Skip to main content

Featured

Golden Rules Of Investment

12 GOLDEN RULES OF INVESTMENT Live by these 12 rules and let your money grow!  1) The past is irrelevant –   Do not rely on past performances and build castles in the air. Invest for tomorrow and live for today.  2) Opinions can hurt. Don’t ask too many people –   just don’t!! To each, his own. What works for someone else, may not work for you and vice-versa. Your investment plan should be as unique as the back of your hand. More importantly, it must suit you best.  3) Everyone’s journey is different. Understand yours. –   Do not invest if you’re not clear on the purpose. Do not draw parallels with other investors. Your need for investing, risk appetite, and nature of investments is of utmost importance. You need to understand what you are doing.  4) Don’t allow your ego to engage with professional advice –   Trust your financial advisor! Google can give you lots of information but your advisor will tell you what’s best for you. Listen and then act!  5) Overthinking will never allow
Post a Comment
Read more
Labels

Joining Text From Different Cells In Excel

 Joining text from different cells

There are many times in Excel when you want to join text that's in different cells. This example is very common, where you have first and last names, and want to combine them as first name, last name, or full name. Fortunately, Excel lets us do that with the Ampersand (&) sign, which you can enter with Shift+7.

1. In cell E3, enter =D3&C3 to join the last and first names.

2. SmithNancy doesn't look quite right though. We need to add a comma and space. To do that we'll use quotes to create a new text string. This time, enter =D3&", "&C3. The 8","& portion lets us join a comma and space with the text in the cells.

3. To create the full name, well join first and last name, but use a space without a comma. In F3, enter =C3&8" "&D3.




Labels:

Comments

Post a Comment

Popular Posts