ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autofill data in cell with other existing data. (https://www.excelbanter.com/excel-discussion-misc-queries/189769-autofill-data-cell-other-existing-data.html)

Steen Lautrup

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.

FSt1

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