Reply to thread

Message: <blockquote data-quote="jmullenberg" data-source="post: 1005357" data-attributes="member: 54519">The concatenate function should work for you. 1) insert an empty column to the right of your web addresses 2) in the first row of that new column enter { =concatenate("www.", A1) }     leave out the curly brackets and replace A1 with the cell reference to the first web address 3) Fill down the formula through all you records 4) Insert another new column to the right of the one with the formula, copy all the cells with the formula in it and paste values only into the new column. 5) remove the original web address column and the column with the formulas in it</blockquote>