If you edit files in various formats day-to-day, the universality of your document solution matters a lot. If your instruments work with only a few of the popular formats, you might find yourself switching between application windows to clean phone number in CWK and handle other file formats. If you want to get rid of the hassle of document editing, go for a solution that will easily handle any extension.
With DocHub, you do not need to focus on anything short of the actual document editing. You won’t have to juggle applications to work with various formats. It will help you modify your CWK as easily as any other extension. Create CWK documents, modify, and share them in one online editing solution that saves you time and boosts your productivity. All you have to do is sign up a free account at DocHub, which takes only a few minutes or so.
You won’t have to become an editing multitasker with DocHub. Its feature set is enough for fast papers editing, regardless of the format you need to revise. Start by registering a free account and discover how easy document management can be with a tool designed specifically for your needs.
all right you get a data set with a bunch of phone numbers and they look like this uh not consistent pretty messy and you would like to get your phone numbers like this in column b and there is more than one way to do that but were going to try to use a formula and you can tell theres a long and complex formula in my formula bar to get started a couple of functions that you should be aware of one is which is really interesting its called sequence so the sequence function allows you to fill uh an x number of uh digits basically one two three four five and so on and you can specify how many you would like to get now you can also specify how many rows or columns you would like to get and then you get a sequence of numbers so thats the sequence now instead of hard-coded values in the sequence numbers we can get a length of a text string so and thats the length function which is im going to reference this cell right here it will give me as many sequential numbers as i have the length