Remove Last n characters from cell in excel

Remove Last n characters from a cell in excel

For Example

A1 = Juhl Lars Mette

We want to trim it as Juhl Lars only

First, we need to identify the number of characters in a text string

=LEN(A1)

Second, how many characters to avoid including space. Here 6

=LEN(A1)-6)

Final Step Answer will be "Juhl Lars"

=LEFT(A1,LEN(A1)-6)

List the Sheet Names with Formula in Excel

List the Sheet Names with Formula in Excel

You can list all of the Excel sheet names within an Excel workbook with a formula using the following steps;

Go to Formulas Tab

Click Name Manager or Press Ctrl F3, to open Name Manager

Click on New

Name: Sheets

Refers to: =GET.WORKBOOK(1)&T(NOW()) 

 

Then Click OK

Click Close

Click cell A1 in worksheet and put this following formula:

=LOOKUP("zzzzz",CHOOSE({1,2},"",INDEX(MID(Sheets,FIND("]",Sheets)+1,255),ROWS(A$1:A1)))) 

Drag the formula down.

The Excel formula should now produce sheet names.

Failed to Establish the connection to the Server. Kindly restart the Emsigner - GST Portal

Failed to Establish the connection to the Server. Kindly restart the Emsigner - GST Portal

Install latest Java and Emsigner
Exit the Emsigner from the system tray icon
Run Command Prompt as admin and type the following commands
netsh ENTER
interface ENTER
port proxy ENTER
add v4tov4 listenport=1645 listenaddress=127.0.0.1 connectport=1585 connectaddress=127.0.0.1 ENTER
Next Open Chrome Goto Settings > Advanced > Content Settings > Javascript
Under allow, tab Click add on the right side - and add these two addresses
https://127.0.0.1:1585 and also https://120.0.0.1:1585
Restart Chrome and type the link https://127.0.0.1:1585 and ENTER
on advanced link CLICK Proceed
Next RUN Emsigner as ADMIN

NOW ITS WORK PERFECTLY

How to make money on Youtube

The most effective method to Make Money On YouTube – Step-By-Step Guide To Success

Profiting on YouTube isn't as difficult as it looks. There are a great deal of approaches to profit on YouTube. A couple of them need a well known channel anyway even a smaller channel may also get you some cash if individuals relish what you do and how you do.

YouTube is a gold mine that empowered numerous individuals to live up their dreams. YouTube has also enabled many people to go fulltime instead of a regular job. YouTube is the second greatest web engine after Google to do such a gigantic business. Lot of individuals moved toward becoming VIPs by clearing their path through YouTube. Justin Bieber and Alan Walker are one of them. There are individuals who recorded a yearly salary of $15 Million every year just from YouTube.  

Setting Up a YouTube Channel

Today, every PC client has a Google account (Gmail). You can begin with a similar Google account or make another one with a particular name according to the idea of the business.

Open YouTube and sign in using your Google account.

Give a name to your channel. Set a reasonable title for your channel.

Verify your channel using your telephone number.

Your YouTube Channel is good to go to transfer recordings.

At the upper right-hand side of the screen, click on the link which says, 'Creators Studio'.

Now browse through the page, configure settings and enable monetization.

Make And Upload Video

Now you setup a YouTube channel and designed, you can make quality videos and share it on your YouTube Channel to gain cash from YouTube.

Sorts of Videos

There can be different sorts of recordings on YouTube. You may classify them in the below categories.

Tips
Gaming recordings
Music recordings
Interesting recordings
Short movies
Video blogs

Empower YouTube Settings Page

While transferring a video or using a video supervisor, you may arrange your record to monetize your videos. Arrange settings to give Google a chance to show promotions on your video. Google's AdSense highlight advances individuals or brands on your videos or sites, and they pay you according to views.

The amount how much YouTube Pay?

Different factors and conditions decide what amount does YouTube pays. The tally of perspectives on your video is the greatest factor to gain cash from YouTube. YouTubers ordinarily win about $1 to $4 per 1000 perspectives from Google AdSense. YouTube pays dependent on the promoter's picked advertisement type which can be either on a Cost Per Click (CPC) or Cost Per View (CPV) type.

Each view should meet the base commitment of more than 30 seconds. YouTube AdSense likewise shared your income which is about 45% of your promotion income. Which means for each earned Dollar, you'll have to share 45 Cents to YouTube and the remainder of the 55 Cents will be credited to your record. Regularly scheduled payout gets attributed between 21st to 26th of consistently. What amount does YouTube pays relies upon the amount you reliably chip away at YouTube.

How to solve the problem of Windows 10 signed in with a temporary profile

How to solve the problem of Windows 10 signed in with a temporary profile

Press Windows Key + R button, it will open the RUN Command

Type regedit and enter. It will open registry editor

In registry editor, browse

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

Expand the Profile List key and find the key that has .bak added to it.

Delete the key that has the same string of characters, but DOES NOT have .bak next to it.

Rename the key with .bak.  Just delete the '.bak' part and hit enter.

Close the registry editor and restart the computer. 

It successfully gets back to your profile.

How to send emails from Google Spreadsheet

First, we need to go to Google Drive to create a new spreadsheet.
Give a name to the spreadsheet
Go to Tools >> Script Editor
Copy and Paste below code
https://github.com/gsuitedevs/apps-script-samples/blob/master/gmail/sendingEmails/sendingEmails.gs



Give a name to the script and Save.
Go to Spreadsheet, enter email address in column A and the email message to be sent to that person in column B

Go to script editor and select the sendEmails function and Click Run
Also, you need to authorize to use Gmail to send messages on your behalf.
Click Authorize Button
After Authorization Click Run it again
Its Done…

Change Default app settings in Vivo phone

Change Default app settings in Vivo phone

Go to Settings, Click More Settings, then click Permission Management,  Click Default app Settings. There is an option for Browser. Select the application for default...

How to stop windows 10 updates

How to Stop Windows 10 updates.

The first step:
We can use Group Policy editor tool. First press Windows + R button in Keyboard. It shows the Run window, type gpedit.mscand and click OK. After that, go to the following location:

Administrative Templates \ Windows Components \ Windows Update

Double-click on the Configure Automatic Updates button and click on the pop-up menu that comes with Enabled, then select the Notify for download and notify for install option and click the Save Changes button. Done...

The second step:

First press Windows + R button in Keyboard. It shows the Run window, type services.msccommand and press Enter. after the pop-up window appears, click on the drop-down menu next to Startup type, and then select the Disabled option and press OK.

After restarting the computer goto Windows 10 Update Panel, click the Check for updates button. An error message will show stating that it is unable to verify the updates. Also, click the Advanced options button and note that you are not allowed to make changes to the download method. Updates where you will see a message "Some settings are managed by your organization".

How to send message in whatsapp without adding contact

WhatsApp gives an official method to chat with an unsaved number. You can start a chat with any number by logging to the web address https://wa.me/phonenumber. Change the last part with the full number, with the country code

For example, if you need to talk with the number +91-93xxxxxx00 in India, you logging to the URL: https://wa.me/9193xxxxxx00.

It automatically opens WhatsApp and you can easily send messages to that number

How to download an embedded private Vimeo video?

First, open the page where there is the video embedded.

Right Click, Select Inspect (Ctrl + shift + i)

Choose the Elements tab.



Click the first button which contains a cursor

Select an element in the page to inspect it and click on the video itself.
This will select the video element in the Developer tools.
Scroll down a few lines, you will find a SCRIPT tag. < `script >



Copy the contents inside the SCRIPT tag to a text editor like Notepad



You can easily find the mp4 video URL with text search in your text editor.