Results 1 to 7 of 7
  1. #1
    Office 2008 (Excel) Problem

    Member Since
    Oct 26, 2009
    Posts
    25
    Office 2008 (Excel) Problem
    Hi Guys

    This may sound real stupid but I have the following issue which I am hoping you can help me with...

    I have just sorted out a database in Excel 2008 (mac) but 1 of the fields which is for web addresses does not have the 'www.' before it..... Example:

    google.com
    youtube.com
    hotmail.com
    bbc.co.uk

    Now, ..... I have just under 4000 fields with web addresses in that are like the above (don't have the 'www.' in front and so don't link to the web).
    Does anyone know of a way for me to put the 'www.' in front of all of the addresses without having to spend ages doing it manually for each individual field?

    Any help would be amazing

  2. #2
    Office 2008 (Excel) Problem
    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,828
    Specs:
    Mac Mini Core 2 Duo
    I was thinking that using the Replace command could shorten the process, but I've concluded that it could leave you with a bigger mess. I did a test, and if you do a replace ****.com with www.****.com it will actually give you www.****.com which is not what you want. I was hoping it would leave the **** as the actual text and all four-letter domains would update. But, it won't. I'm not aware of any command that will add something to the beginning of designated cells. Maybe someone who knows about scripts could come up with something.

  3. #3
    Office 2008 (Excel) Problem

    Member Since
    Oct 26, 2009
    Posts
    25
    Hey

    Thank you very much for your suggestions, although it doesn't directly help with my issue, I do very much appreciate your time and effort in trying to help with my problem.

    Mark

  4. #4
    Office 2008 (Excel) Problem

    Member Since
    Apr 27, 2008
    Posts
    92
    Specs:
    MBP 2.5 Intel Core 2 Duo, 2GB 667 MHz DDR2, 17" Hi-Res Display ; iPhone 3G 2.1
    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
    "Sure, I could compare PCs to Macs. But I make it a point to never argue about religion."

  5. #5
    Office 2008 (Excel) Problem
    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,828
    Specs:
    Mac Mini Core 2 Duo
    Very cool. I'm familiar with the term, but didn't know it was an Excel command. There's a little bit of jumping through the hoops there, but obviously less work than paste, paste, paste, paste.... that many times. Here's what Excel Help says about the command:

    CONCATENATE
    Joins several text strings into one text string.

    Syntax
    CONCATENATE (text1,text2,...)
    Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

    Remarks
    The "&" operator can be used instead of CONCATENATE to join text items.
    From that, I would think that there is no need for the quote marks around the www. and in fact, you wouldn't want them, because they would become part of the concatenated text string. I would think that the = is required, but it's curious that it is not noted in Help. Perhaps someone can confirm those things for you before you try it.

  6. #6
    Office 2008 (Excel) Problem

    Member Since
    Apr 27, 2008
    Posts
    92
    Specs:
    MBP 2.5 Intel Core 2 Duo, 2GB 667 MHz DDR2, 17" Hi-Res Display ; iPhone 3G 2.1
    You do need both the = and the "". if you dont wrap it in double quotes then it thinks its a cell reference, and you need the equal sign to let it know that it is a function.
    "Sure, I could compare PCs to Macs. But I make it a point to never argue about religion."

  7. #7
    Office 2008 (Excel) Problem
    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,828
    Specs:
    Mac Mini Core 2 Duo
    The "instructions" in Mac Help are poorly written then, I'd say. But, that's not unusual. Thanks for a great tip. I'll have to file that one away in my memory bank.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MS Office 2008 Data Entry Excel help!
    By missekp in forum OS X - Apps and Games
    Replies: 0
    Last Post: 12-18-2013, 09:26 AM
  2. EXCEL (Office 2008) running slowly, freezing?
    By Annettest in forum OS X - Apps and Games
    Replies: 4
    Last Post: 01-21-2010, 05:33 AM
  3. Super-/Subscript in Office Excel 2008?
    By pandaen in forum OS X - Apps and Games
    Replies: 2
    Last Post: 08-24-2008, 09:05 PM
  4. Excel office 2008
    By christ30mac in forum OS X - Apps and Games
    Replies: 0
    Last Post: 07-07-2008, 01:26 PM
  5. Office 2008: Excel problem
    By Liam in forum OS X - Apps and Games
    Replies: 0
    Last Post: 05-21-2008, 03:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •