Skip to main content

Posts

How to separate values from the single column into multiple in Excel

There are many functions in Excel which are exceptionally useful and allow us to execute critical tasks in a very straightforward and quick route. Here is one more feature which would enable you to extract the data from one column to multiple. Below are the steps you need to execute to achieve this. 1. Now take the instance of the table in the below screenshot. There are three values presented in this table. 2.  Suppose you want to split first text itmacron@profession.com to different cells to itmacron profession.com by removing ' @ ' sign from the middle you need to follow the below steps to do so. 3. Select the entire Column and then Proceed to the ' Menu Bar'   and choose ' Data '  and then click on ' Text to Columns'  (circled in red in the above screenshot). 4. In this window choose ' Fixed width'   with the radio button and click ' Next ' . Further, in the following dialogue box check the ' Other'  option and enter ‘@’...

Combine two or more columns in Excel with or without space

Excel has become an inseparable part of every professional’s official operations. With the vast scope of segments and tools, excel can transform data into an expressive and analytical statement which allows us to present our unmanaged and massive data in a more approachable and clarified manner. Now, here are a few steps you can follow in order to incorporate two or more cells’ data into one Take an example of below table here 1.        Here, if you desire to combine A, B & C columns with no open space between each word. For example, Marry+Jones+Peter= MarryJonesPeter , Please use below red highlighted Formula: Formula is =Cell1&””&Cell2&””&Cell3 and so on… 2.      However, if you want a proper space between each word which makes more sense in many cases. For instance. Take a second example from the above image. If you want to merge Nany +Kaul+Nasa into Nany Kaul Nasa ,   ( Noticed spaces between each w...

Ten extraordinary facts about iPhone 13 Pro

Apple has consistently stunned us with their jaw-dropping iPhone models and their features. The lethal blend of Camera, Pro-motion display quality and A15 bionic chip is a rare thing to have in any phone, but Apple has accomplished it effortlessly. Also, their iOS is so full of supreme features that its functionality cannot be defined in any phrases. Here, i will underline a few noteworthy attributes about the new iPhone 13 that you will treasure. 1.        Macro photography Macro photography is a craft that causes small objects to look life-size or gigantic. Little objects can be generated with astonishing detail that cannot be experienced with the bare eye or a common lens. To our surprise, Apple has added this wonderful feature to the new iPhone 13 that is extremely addictive and provides an unbelievable adventure to the user.    2.        Improved Battery Life Flawed battery back-up is a known downside in man...

Must have Laptop accessories on Amazon in India

The new laptop comes with all the necessary things, which are needed to keep it up and running however, there are many more items that can not only add more delight and excitement to operating your laptop but also accelerate the laptop's performance. So why not try some practical accessories which are readily available online.   1. STRIFF Adjustable Laptop Stand Patented Riser Ventilated Portable Foldable Stand   Nowadays, everyone spends long hours in front of their laptop doing personal or official stuff and having a bad posture can negatively affect your body as well as mind. How about having a podium where you can rest your laptop or tablet and be able to accommodate it as per your necessity. Agree or not, it is true how good we feel when we are not hunched towards the screen, straining our eyes, neck, wrists, or even our shoulders. We don’t even acknowledge how this can have untoward repercussions on our bodies. Buying this stand would be the most useful investm...

The top add-ons for your new iPhone 13 in India

iPhones are themselves a pack of marvelous features and unique technology. However, the potential can further be extended by adding a few wonderful bunches of accessories. Whether you buy out-of-box headphones or a great wireless charger your iPhone battery. I would provide you with a list of accompaniments that can add more fun to your adventure of using your new iPhone. 1.  RAEGR MagFix Arc M940 15W Mag-Safe Compatible Wireless Charger Everyone is very well aware that the new iPhone comes with no charger. Though it is not an expectation that we have from such a pricey purchase, this is how it is. We can have chargers available lying around the house from the old phones, which can be re-purposed with the new iPhone. If not available, I may have the best tip for you and that is  Raegr MagFix Wireless Charger.  It charges your phone within a few minutes and has in extremely good shape       Descriptions: Type :   Wireless   Charger Compatible...

Battery drain issue in new iPhone 13 and learn how to rectify it?

It is quite a comprehended issue of getting the iPhone 13 battery exhausted over the night. There are several causes why this is happening with your new apple phone, and here is the list of steps you can do to rectify this problem Remove unwanted applications                                                                                                                                                                                                                    ...

Frequent and common problems with new Apple Touchbar Models

There is no doubt that Apple Laptops have unique abilities and features which are unbeatable by any other kind of machine. However, with the new model releases, especially the post Retina Model there has been an immense wave in the hardware cases reported by the users. I want to provide the details of the problems and precautions you should be aware of while handling these expensive machines.    Display sensitivity , the LCD for this most delinquent Touchbar model seems to be very flimsy and can easily be damaged. There have been cases where users unexpectedly damaged the lower side of the LCD while cleaning. So keep in mind the level of sensitiveness of the display glass while using these machines and handle with care. Motherboard faulty  this problem is fairly typical in the Touchbar model. If you miss restarting the machine every day and important updates, leave your laptop on standby for numerous days and use your laptop on the bed which stops the ventilation, it can ...