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!
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.
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.
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.
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.
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.
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?
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
To get rid of ACME & i would highlight the column (minus header) and Find and Replace. Find "ACME &" replace leave blank.
That is by far the easiest thing to do. No need to use a formula when every row in the column contains the same format.
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.
I used to do that too! But the formula method it's nice too.
@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
What if there are ACME in many other columns which we do not need to replace?
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!
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.
Thank you for this information. There is also another way that I learned to do this and that is with "Text to Column".
ua-cam.com/video/RhamuSEieQ0/v-deo.html
We can use text to column to remove the ACME & from campaign column
This is very helpful because I was cleaning up numbers which was not all the same. Thankl you
Does anyone know where to download the practice file for this lesson? Couldn't locate it on the Skillshare site. Thanks.
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.
How could anyone not benefit from this and give a thumbs down...
Too much talking and repetition
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.
There is a much easier way. Select column, CTRL+H, replace what you want to remove with a space. Done in 2 clicks
Provided everything starts with 'ACME &' like in this case.
Looking at the consistent nature of data Using fixed width can be of gr8 help as well
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.
this doesnt work if you have already used the =proper to clean data?
Wow. Super helpful. Thanks
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.
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?
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
Class 1 is here on Skillshare: skl.sh/1NqDpCT
Dude this is 🔥
thank you. please, what's the copy of this excel. if possible, the link of this copy. it's very good appearance.
hey can you please share the links of all the excel tutorials ?
Great video but one thing i missed here that you are not providing the excel sheet that you have used in this video.
We've added it to the description 👍
Hi Chen, if you could provide a link to the dataset please
Where is this guy from? I love his pronunciation!
Hi, where can I download your excel file to practice? Thanks
Keggle database
Now what about getting rid of stuff at the end of a string like on every folder import
unable to find the unit 1; can someone tell me where it is, please?
They are all on Skillshare. Just search for "Excel for the Real World" on Skillshare.
Hi Al. I appreciate this video. You mentioned this is Lesson 2 and that Lesson 3 will be Analysis. Do you have Lesson 1 and 3 on UA-cam? Thanks.
Hi! Unfortunately these classes are only on Skillshare. Just search for "Excel for the Real World" on Skillshare.
Can i get the dataset ?
you could've just used find and replace or the left function. that's way too much work
@Selim. Can you please show me how the left function works in this case?
how can i get more excel lessons from you?
Control + F and replace “ACME &” with “” would have done this in a fraction the time he took to explain this
Can I get dis file for practice
Just added it to the description. 👍
Cann't find lesson 1, can anybody share it, please?
Hey Thida! The full class is on Skillshare and accessible through a free trial: skl.sh/2qqOH79
Thank you very much!
How look up speeling mistakes
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..
TQ
share excel file with us
WHO TF USES EXCEL ON MAC
people who need to use excel and own a mac, love the depth of the question though
I hear sirens :)
This guy elaborates way too much.
ex. accme
confusing alot fail
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
Class 1 is here on Skillshare: skl.sh/1NqDpCT