(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 kommentar(er)
