Results 1 to 10 of 10

formula to wrap a cell input in preset wording for that cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    NO VA
    MS-Off Ver
    2007
    Posts
    4

    formula to wrap a cell input in preset wording for that cell

    I'm new to excel, so if this is not a formula question, then I apologize. I'm not sure what the proper wording is for what I need. I'm building a spreadsheet that will import data into a website. One of the columns will hold shortcodes for woocommerce. An example of a cell in that column looks like this

    [products skus="liberty, june, abbadabbado" orderby="name" order="desc"]

    The only thing in the above that will change in each row is liberty, june, abbadabbado. Is there a way to make the

    [products skus=" " orderby="name" order="desc"]

    permanent and only show when I type the info in the cell? So if the next cell in that column was

    abby, firstfrost, neptune

    all I would have to do is type in those three words and it would be wrapped in

    [products skus="abby, firstfrost, neptune" orderby="name" order="desc"]

    and if nothing was in that cell it would remain blank?
    Last edited by monkeyswcrayons; 10-29-2014 at 07:49 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Noob Needs Help With a Formula!
    By Drew Pickles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2014, 10:21 PM
  2. [SOLVED] Noob To R1C1 format, New Formula Received and I Need Help Please.
    By DHartwig35805 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2013, 04:04 PM
  3. Noob question - How to edit a formula across workbooks - shortcut?
    By webbt01 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-04-2012, 07:45 PM
  4. [SOLVED] Conditional Formatting Formula needed for noob
    By Patrick Byrne in forum Excel General
    Replies: 1
    Last Post: 04-04-2012, 05:48 PM
  5. Noob help with a formula
    By tmmgem in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-12-2008, 03:03 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1