Yes, but I think he showing how to use specific formulas. There are many ways you can do things. Text to column is another way. Some make more sense depending on the situation. Find and replace would be easiest based on this example. However in many cases you won't be able to do that and you'll need a formula and I think that was the point he was trying to make.
@Vanessa Herrera if that would had been the case ,then he would not had made this video... Ok lets assume your theory "Find and Replace", but did you noticed one thing the Word ACME & is replaced by BLANK SPACES as this could lead to awful data plus some texts as left, middle, or right aligned
In this situation you can split the column using an option under "Data"- "Text to Column" Then follow the options. You can split your data what ever way you want.
sorry to be off topic but does anybody know a method to log back into an Instagram account..? I somehow forgot the password. I appreciate any tricks you can give me!
very good tutorial. all people below that propose one time replace dont get that the method mention in the tutorial is universal and leaves raw data which can change and produces clean data regardless change of original data.
Text to columns and data cleaning have been explained in detail in one of the videos at "off to office". Apart from the date aspects u will find other interesting usages of text to columns.
Thank you for the video. I have a question, my clients' addresses saved in excel, but each of them separated in two cells, how do I fix them in quick way.
Instead of dragging and dropping to copy the formula, wouldn't you just double-click the "+" symbol that appears when you hover the cursor over the bottom right corner of the cell?
I was given an excel sheet with park trail data to analyze. columns to analyze are in percentage ranges.ex: Grade =20%-25%, side slope =30%-40%, out slope 0%-5% . How do I clean this up?
I have a question can you help me out. I have data of numbers from 0 to 36. I have data of number in lakhs. I have to arrange all number after one number. Suppose for example. In data thousand of times 0 there. I need next numbers which come after 0s. Same as upto 36.
I understand but my data have Sidhgora Market, Jharkhand Sinhgad College, Maharashtra Devanhalli, Karnataka Phulbari site_1, Bihar. so how to suppurate before ',' is Capital or location and after comma as State.
Hello Al Chen, thank you for this lesson, it's been so helpful,... could you pls send the link to the class 1 as you have mentioned in this lesson. thanking you
The title seems a little click baity. I’m hoping that other lessons or tutorials on skillshare have a higher level of competency or complexity involved..
Hi Al Chen, thank you for this lesson, it's been so helpful,... could you pls send the link to the class 1 as you have mentioned in this lesson. thanking you