How to copy Word table into Excel without splitting cells into multiple rows?

Honestly we work a lot on Word, Excel and PowerPoint, to an extent that we never thought while we were in school or university that this is what we would end up doing ultimately.

This makes it immensely important that we know some nifty tricks to quickly work our way out, on to the next job. This has been a long pending work for me and this time I had to look for a solution (because the data size was huge and i couldn't do it one by one).

And here is how we do it:

In Word:

1. Select your entire table in Word.
2. Open the "Find and Replace" dialog (or Ctrl+H).
3. In the "Find what" field, enter ^l (Shift+6 and the first letter of word lion).
4. Now when you click on Find, it will search for all the line breaks. If there are no line breaks then look for paragraph breaks.
5. You may select paragraph breaks by entering ^p (Shift+6 and the first letter of word parrot).
6. In the "Replace with" field, enter ^v (Shift+6 and the first letter of word Venice).
7. This is a shortcut for the paragraph symbol ¶. This is also known as a "pilcrow".
8. Click "Replace All".

Now copy the table data from your Word file.

In Excel:

1. Paste the copied table in Excel.
2. With the data still selected, open "Find and Replace" (or Ctrl+H).
3. In the "Find what" field, enter the following Alt code: Alt+0182. This is the Alt code for the pilcrow symbol. To enter an Alt code, ensure the numeric keypad is available (i.e., Num Lock on).
4. In the Replace field, enter the Alt code: Alt+0010 (this is for the line break). Nothing appears to change but it works.
5. Click "Replace All".

And that's it. All the rows copied as is without splitting of content into multiple rows.

Hope this helps! Until next time.

Sign out of a single Google Account instead of signing-out of all

When you login to multiple Google Accounts on your browser, Google links them all on the client side. If you want to sign-out of an account, this unfortunately isn't supported by Google. You'll need to log out of all your accounts and sign back into the one's you want to again. This is for security reasons.

I haven't even found any workaround to this. Tedious but true.

Suggestion: Use incognito instead. If you want to sign into multiple account, instead of using the same browser instance, open the incognito and login to another account from there. So you can only logout of that account.

Hope this helps! If you have any other suggestions, mention in the comments below.

Boundaries and limits for SharePoint Online

With various SharePoint Online plans like Office 365 plans and standalone SharePoint Online Plan 1 and Plan 2, the software boundaries and limits definitely seems to turn your head upside down.

This page explains these in detail for all current Office 365 plans including enterprise, educational, government, kiosk plans as well as standalone SharePoint Online plans.

iPhone 7: Here's what to expect [leaked videos]

Every thing SharePoint 2016: Server roles based configuration wizard

SharePoint 2016 introduces new server role based farm configuration like you see in the image below.

I would think the role is actually based on the services that will be running on the server however, the rules are yet not been suggested by Microsoft.

One thing to ponder, Is this the beginning of the end of "3-tier architecture" deployment of SharePoint?

SharePoint 2016, InfoPath and its alternatives

SharePoint community has been given a peak by Microsoft at its plans for the on-prem version on its most popular collaboration platform.

Get more info by clicking on this link

On form solutions, Microsoft is researching a web-based solution for the design and creation of forms, (says Microsoft MVP, Asif Rehmani) while InfoPath will be phased out with ease. Microsoft has not made anything official yet and nobody knows any timelines of a production release.

Meanwhile, a few alternatives to InfoPath forms are Nintex, K2, AgilePoint, he suggests.

Get current Year and store in SharePoint List Column

Create a List Column in SharePoint.

Select the type as Single line of text

In Default value select Calculated Value and enter this command

=TEXT(Today, "YYYY")