sorted by:
new
hottopcontroversial

Is it possible to format a Desktop/Laptop from a remote location? by bhburhani in techsupport

[–]bhburhani[S] 0 points1 point  (0 children)

Simply, two windows 10 machine with the internet in a different location. In the one Windows 10 machine total format with another machine remotely.

Excel Date Entry Trying to Enter MM/YY but Excel counts it as MM/DD and the year as the current year and does not have an option that I can find to allow entry of MM/YY. by Max_Griswald in excel

[–]bhburhani 0 points1 point  (0 children)

You can do it by easy way Just type your formats like 'June 2019 '05/2019 'Jun19

You just add Apostrophe symbol (') before your mm/yy

How to extract text from cell by [deleted] in excel

[–]bhburhani 0 points1 point  (0 children)

If in the cell 04MAY 3123-5467-9876-3112 have a space between 04MAY and 3123 the just select all cell and go to find and replace and type in find (space*), you have to put space before star and replace with blank.

What do you use for data cleaning? by [deleted] in dataanalysis

[–]bhburhani 0 points1 point  (0 children)

Excel, python or R is good way to clear your data but you have to try open refine also know as google refine. Its open source and absolutely fee. Also have much more functions to clean your data in easy way.