![]() After typing the first three digits (722), you will see this happen:Įxcel will fill in the format you need for the rest of the phone numbers. Go to the next cell of the column and start typing the next phone number. Type the right format of the first phone number in a new column (e.g. However, Excel 2013 offers an even quicker way of doing it by using Flash Fill. In previous versions of Excel, you could use a formula for that. ![]() If you need to change the format of each phone number to 395-6492 instead of 3956492, inserting a hyphen in every phone number by typing is a lot of work. If you need to make a couple of new columns out of this data, you can use Flash Fill. For example, let’s says it’s the names of your customers and their seven digit phone numbers shown in the Home Number column below. ![]() You have a long list containing huge amounts of data. Let’s demonstrate using Flash Fill with some examples.ġ. Microsoft Visio 2010 – 9 Hours Video Training.Power Pivot, Power Query and DAX in Excel.Adobe Photoshop Elements 11 – 12 Hours Video Training Course.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |