![]() Be sure just the filled cells are selected and COPY them (ctrl+c or right click and choose copy). Do not click the column header to select. (6) Once you've varified that everything is correctly copied and formatted (the correct numbers are represented), select all of the cells in that column. (5) Copy that formula down each row to the bottom of the data. (4) Now, assuming you're on row 1 column D, the formula would look something like this (modify as necessary): (3) Use the empty column to the right or left (insert one if needed) of where all the resulting columns of data reside. (2) Use text to columns to split those numbers to as many columns as you need. (1) Your numbers with spaces are all in column A to start with. Now, using the empty column to the right or left of them (insert a column if needed), use the CONCATENATE function to put them all back together inserting a decimal where needed. The procedure is the same.įirst, split the address into as many columns as needed using text to column feature like you did before. Do you mean IP addresses with decimals? No matter. ![]() You said MAC addresses and the one's I've seen have dashes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |