Autofill data in cell with other existing data.

  • Thread starter Thread starter Steen Lautrup
  • Start date Start date
S

Steen Lautrup

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula autofill to cells below – formula arguments are cell areas in different columns 1
HELP!!! I need macro to autofill 4
AutoFill Macro Issue 1
Macro to autofill from a specific row to a specific row 2
AutoFill double click does not work in Excel 2007 3
Auto Fill Cell Based on Data in a different cell 4
AutoFill 1
Autofill & On Error Resume Next 2

Back
Top