![]() |
Autofill data in cell with other existing data.
I have a range of cells, a column, with a lot of domains. for instance;
svanholmelektro.dk, I need www. first in all of these. |
Autofill data in cell with other existing data.
hi
you can use a helper column and a formula. lets say your domain data is in column a. add a blank column B. in column b... ="www." & A2 copy down. copy column b and pastespecial values. to turn the formula in to hard data. delete column a. Regards FSt1 "Steen Lautrup" wrote: I have a range of cells, a column, with a lot of domains. for instance; svanholmelektro.dk, I need www. first in all of these. |
All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com