Embroidery with Illustrator

Friday, I should have been playing the FML theme song. I found a plugin that is compatible with illustrator, and it only works with the PC version of my CS6 license exclusively for Mac … FML!!!

The tutorial seems like what I wanted, but it’s more expensive than the Bernia software: 

After some research I was able to answer the question: How much would it be to get a CC license and buy the Embroidery i2 plugin? Looks like it would be $20/mo for a year for Ai CC. Two years of that would exceed the price I paid for multiple programs, but they are only licensed for use on my Mac, not my PC … even so. DANG!

There was someone asking about the Embroidery i2 plugin a few years ago on the Adobe forum.. my response is as follows: 

I’ve been heavily researching this topic… The tutorial video looks like it would be perfect .. However, it’s not compatible with my version of illustrator on the operating system my license is for… so to pay $20/mo for a program I already have and pay $3500 for the plugin PLUS annual fees of $1500… *sigh* it’s everything I’ve been looking for and “surprisingly” its NOT affordable (for an amateur such as myself). Figures, I think more and more every day Embird Embroidery Software is winning. In response to the other comment, Embird and programs that are compatible with vector drawing don’t auto convert. Certainly, auto conversion/ auto tracing is not ideal… just like in Illustrator. However, when you import your vector file the goal is to use the vector paths/curves to make the design the way you want it sewn.. without having to re-draw a logo (which is not advised). Embrid PLUS Font Engine Plug-in = $400-$500 (How to Import Vector Graphics with Embird. Unfortunately, the trial version of the software doesn’t let you try it out and I have yet to see a decent tutorial on it). However, my findings are that this combination is the obvious choice. Even with this illustrator embroidery plugin; you would still need to learn how to use the plugin like any other embroidery software. So you might as well buy a new program, built for the trade, that fits your budget. Additionally a software with numerous free tutorials available to help you learn how it works. Sadly, Embroidery i2 for Adobe Illustrator was too good to be true 

Sounds like I need to buy Embird. I don’t think my 2003 Embird license and my 2003 Font Engine is compatible with the vector import feature. The menu is totally different now, and I can’t figure it out if it does or not..  which is a bummer. Perhaps, I could buy the base program and Font Engine Plug-in (with vector import feature) for my birthday, at which point I would feel better about spending that kind of money.  In the end, it would be worth it. 

Embroidery Software and Getting Started

Lately, I’ve had a need for a creative outlet. Recently I was inspired to look into how embroidery sewing machines work. More specifically, what would be needed to turn a vector drawing from Adobe Illustrator into an embroidery design compatible with my machine. I recently got a Bernina Artista 200, and it has been upgraded to be flash drive compatible. The upgrade turned my machine into a Bernina Artista 730. The internet alludes to the fact that these machines are more particular on what size of drive it wants to work with. In fact, the .exp files are quite small and do not need much space. So I was left with the question, what can you do to convert a large flash drive (from a trusted brand/ aka not a cheap one from China) into a small flash drive that is compatible with the sewing machine?

IMPORTANT note: most small flash drives–especially the ones that come from China or a similar areas–are NOT safe, and could contain computer viruses. I have many flash drives from trusted brands that I use all the time. A workaround this problem, is to format your flash drive and “partition” the available space to the size you need. I took an 8GB flash drive and told the drive it only has 256MB to write to. This way the flash drive acts like a small drive that will be compatible with machines that only want a smaller flash drive, like the Bernina Artista 730. I found a WordPress blog called Time Science that walks through how one might accomplish this, How to Downsize a Flash Drive..

I learned that the Official Bernina USB Stick is not necessary from Hoop Lah Carolyn Keber’s Blog, in her article Bernina USB Data Pens. Carolyn uses an Embroidery Program called Embird and she saves her designs as .exp files. I learned about Embroidery File Formats on youtube from Ultimate Stash Embroidery. He taught me that the embroidery master files types are .dst or .exp and they will work using any embroidery machine as well as the file type that is specific for your machine, in my case that would be .art, .pec, or .pes.

I also learned on Carolyn’s Blog about the free software available on the Bernina website for design transfer. It’s called ARTlink 8, I downloaded it and have yet to play with it. Seems like a promising way to write the file to the drive vs. drag and drop. My attempt to download .art files from the Bernina website and drag them to the flash drive I formatted was unsuccessful. I’m thinking the “write to machine” function is necessary for the files to be visible to the machine. I also don’t think I plugged in the drive before tuning my machine on, which was recommended.

My quest started by wondering if I could take a design I created with Adobe Illustrator and use an embroidery plugin to automate the design and not need an expensive hard to use embroidery software. I’ve learned that an embroidery software is needed and I can use my Illustrator skill set to trace a design with the Embird Studio and using the digitize tools. I’ve learned that this program is capable of auto trace, and if the density map shows green and yellow vs. red it will work OK. Just like in Illustrator the trace option is not as good as re-drawing your points with the pen tool. Embird has a tool like the pen tool that will help you define the outline of your design, and then add stitching to fit the design. It also has shape tools and layers similar to the Adobe Illustrator workspace. Once you are finished you can save the .exp file. Then use a program that can transfer the .exp file to your memory stick, like ARTlink 8. Turn off the machine and plug in the drive (Use flash drive as a transfer device, do NOT store your designs on it.. This tip is based on–the amount of time the drive takes to transfer depends on how many designs are on your stick. Keep it Simple Silly!). Turn on machine an click the USB button, on the Bernina this will be on the touch screen. Now use you machine to print the design to the hoop size it was created for.

I’ve learned on the internet Embird is the embroidery software I have been looking for. Instead of investing in the $2,500 Bernina Software (Version 8). Embird also seems more intuitive for someone who already is experienced with Adobe Illustrator, such as myself. All the programs I’ve found have a trial version, so you can always try it out and see if it’s worth a couple hundred dollars. If you only need it sporadically you can keep using the trial version on a virtual computer, or format your computer when you want the trial program again. Embird also has packages you can buy on top of the base program. However, if you don’t need it you don’t have to buy it. Where as, the Bernina Software comes in a big intimidating package; they expect you to get lessons from your local dealer, on top of all the fees you’ve already been hit by…   If I bought all the features Embird offers it might add up to $1,000. Again, I don’t need all the tools Embird has because I have design tools that I am already competent at using. Who knows, maybe later down the line I will feel the need to try the other perks Embird offers.

I found several tutorials on youtube helpful to decide on Embird Embroidery Software. So far, I really like the tutorials by, OML Embroidery. Here’s one of many tutorials I found helpful, Embird Quick Tip: how to digitize like a pro!

Happy Sewing!

Concatenate Formulas with HTML

The following post is to test Concatenate formulas with added HTML to import vendor data for long descriptions. I am going to include several examples that can be used depending on the provided info. 


Demo formula:

=CONCATENATE(E6," ",G6," ",H6," ",I6," ",T6," ")



I’m going for something like this: 

This is a product description. This is a product description. This is a product description. This is a product description. This is a product description. (E6). 


  • Feature 1
  • Feature 2
  • Feature 3



  • Fabric

Continue Reading



The HTML will look like this: 


IF there is 1 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 1 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 1 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")



IF there is 2 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li></ul> ")

IF there is 2 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li><li> ",U6," </li></ul> ")

IF there is 2 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")



IF there is 3 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li></ul> ")

IF there is 3 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li><li> ",U6," </li></ul> ")

IF there is 3 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")



IF there is 4 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 4 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 4 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")



IF there is 5 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 5 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 5 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")



IF there is 6 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 6 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 6 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")



IF there is 7 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 7 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 7 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")



IF there is 8 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 8 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 8 features and 3 fabrics the formula could be:

=CONCATENATE(E169," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G169," </li><li> ",H169," </li><li> ",I169," </li><li> ",J169," </li><li> ",K169," </li><li> ",L169," </li><li> ",M169," </li><li> ",N169, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T169," </li><li> ",U169," </li><li> ", V169,"</li></ul> ")


IF there is 9 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 9 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 9 features and 3 fabrics the formula could be:

=CONCATENATE(E205," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G205," </li><li> ",H205," </li><li> ",I205," </li><li> ",J205," </li><li> ",K205," </li><li> ",L205," </li><li> ",M205," </li><li> ",N205," </li><li> ",O205," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T205," </li><li> ",U205," </li><li> ",V205," </li></ul> ")



IF there is 10 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 10 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 10 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6, "</li></ul> ")



IF there is 11 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 11 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 11 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6, "</li></ul> ")



IF there is 12 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li><li> ",R6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 12 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li><li> ",R6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 12 features and 3 fabrics the formula could be:

=CONCATENATE(E197," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G197," </li><li> ",H197," </li><li> ",I197," </li><li> ",J197," </li><li> ",K197," </li><li> ",L197," </li><li> ",M197," </li><li> ",N197, " </li><li> ",O197," </li><li> ",P197," </li><li> ",Q197, " </li><li> ",R197, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T197," </li><li> ",U197," </li><li> ",V197, "</li></ul> ")



This reference list should work for my current Columbia spreadsheet. Keeping in mind the letter will be the same but the numbers will change depending on the row they need to apply to. Excel will color code selected cells, if the cell ID is not colored this is an indication of where you made a mistake in your formula. 


Finished Reading

Helpful Excel Formulas

This post is a collection of formula’s I have used IRL. These formulas have helped me learn how to manage updates and automate the process to import images and data to my employers website.

How to Change an Image Name into a WebStyle:

*Note – this will only work with styles that include color codes and have the same item number for all options.

This function was used to change the image name into a WebStyle to group each style on it’s respective product page.


My images for the brand CHACO all follow the same format:

  • CHC~J106446~CRP~S18.jpg

This equation gave me:

  • CHC~J106446~S18

Since all these images are of Spring 2018 products, I was able to delete all the characters after my second Tilda (~) and add the test S18 to indicate the product pages would be organized by Season Code.

I refreshed my excel equations with SpreadsheetO’s tutorial, “How to Use the String Functions: LEFT, RIGHT MID and LEN.”

How to Delete the Domain Name in a URL:

I used this equation to change data exported from a website and remove the domain name so I could save the data as a .csv and update the URLs so they do not take the reader to a 404 page.


To update URLs you need headers “OLD URL” and “NEW URL”

My 301 redirect importer needs the http://domain.com in the URL to be omitted. For example, if the full URL was:

  • https://spreadsheeto.com/text-functions/#left-mid-right

I would need to remove 25 characters in the beginning of the cell to get the data I need:

  • /text-functions/#left-mid-right

If your URL is shorter or longer change the “25” in the equation to the number of characters to the right of the part of the cell you want to keep.

Once you have the equation you can apply to all cells, copy the data and Paste Special (Values) into a new column. This should be under the header “OLD URL” now you can edit the next column and define if this page is a 404 page the reader will go to the “NEW URL” instead. 

How to Manipulate Data from the Middle of a Cell:

*Note – this will only work if you change your values to match the characters in a given cell.

This function was used to remove the brand code and season code of a product page to get a starting point for the style as it was entered in the POS.


I need to omit the first four characters, and tell excel to start counting at the 5th character and keep counting for 8 characters, the example was:

  • OSP~10000094~S18

I only want the number in the middle, which is searchable in our point of sales system. When I apply the formula above it leaves me with the style number.

  • 10000094

How to Change the Case of a Cell:

This function was used to copy a product title from the vendors website and format it the way we need it on our dealer site. I’m going for proper here, but you can also format with upper and lower.

  • A Product Page


  • a product page

Simple and practical, thanks TeachExcel on YouTube, “How to make test cells all lower case or upper case in Excel.”

Now here is where it gets tricky, if I have a cell that needs sentence capitalization–where only the first letter at the beginning of the sentence will be capitalized–we need a heavier formula. 

Thanks to Extend Office, “How To Capitalize First Letter Only Or First Letter Of Each Word In Excel?

I found a formula for this:

  • A product page.

How to Transpose from a Column to a Row:

Some of the Vendors give access to pdf catalogs that I can copy into excel. It’s difficult to deal with the data because it is in one column and I need it to be in rows so I can format it with html before I import it.

Extended Office introduced me to an Offset formula that transposes the data from one column into one row. I will need to proof read the copied data before applying the code but it will allow me to compile the data and prepare it for import.


The full tutorial can be found on the extended office website in their article, “How to transpose/convert a single column to multiple columns in Excel?” 

How to Combine Multiple Cells into One Cell:

This function was used to combine multiple cells including parts of the product name to one cell I can import as the product page name. This formula would also work for adding a persons first middle and last name to one cell, if the data had each name in it’s own cell. 

=CONCATENATE(B2," ",C2," ",D2," ",E2)

After practicing the formula I was able to get the desired end result: 

  • Women’s Benton Springs™ Full Zip

Thanks to the DullesDistrict video on YouTube, “Using PROPER and CONCATENATE in Excel” I have the full product page title in one column ready for import. 

I could also use this method to combine all the data for my descriptions, while also adding necessary html, for example:

  • “,B2,”
  • “,C2,”
  • “,D2,”
  • “,E2,”


Given this strategy, IF I have all the items that need to appear in a bulleted list in separate cells I can add html between the quotes in the formula, which will allow me to prepare the data for import.  



  • “,B2,”
  • “,C2,”
  • “,D2,”
  • “,E2,”


Normally I would only include the first break in the HTML, I need to touch base with the developers and get them to fix the spacing between my header and the beginning of my bulleted list. 

How to Combine Multiple Cells to Make a list Separated by Pipes “|” :

*Note – this will only work with data that includes the same number of list items.  

This function was used to combine select cells and add a pipe separator in between “.jpg” file names so they can be imported to the site with a “.csv” spreadsheet file.

I’m using the formula from the Transpose tab here. Depending on how many list items I have I’m changing the “5” in the equation to that number. In my example, I am collecting data from each product and including a default and 3 other alt images. So I will change this integer to a “4”


I begin these projects by copying file names and pasting them into a spreadsheet. This will be a long list in a column. But I need the data for each product in rows.  So I can create one cell with all the images for that item separated by the pipe “|” symbol. 

My list of image names are in column A, and the Formula will be inserted in C1. I will copy the formula to the next four rows C-F. Then I will hover over the bottom right of cell F1 and drag the black cross curser down the list to F10 (or until you start seeing “0” in cells instead of the data). 

Once I have my data in rows instead of columns I will copy and Paste Special (Values) to apply the next formula. I paste the formula below in G12, and copy the formula down to account for each line of data. 

=C12&" | "&D12&" | "&E12&" | "&F12

Now I will copy the data in column G and paste special (values) to get the full list of items needed for my import.  


default-image.jpg | alt-image(a).jpg | alt-image(b).jpg | alt-image(c).jpg

I started with a list of all the file names in a different cell within column A. Now I’ve got the image list separated by pipes located in one cell. 


How to _____:

*Note – this will only work with ________.

This function was used to  _________.




Important Reminder

When working with formulas it is highly advised that once it gives you the data you need in it’s own cell you add it to a new column or document and make it independent of the source data. To do this you can:

  1. Highlight & copy your data
  2. Insert a new column (Or create a new document)
  3. Select the starting point for your data to copy to: example (A2)
  4. Right click, choose “Paste Special” & “Values” (If you create a new document this is not an option and “Text” is the next best thing).

Now your data is independent of the source data & the formula. This helps when you export your data to a .csv file for import purposes. This is a necessary step, because if your equation or source data is deleted you do not lose the data you formatted.

VR Experiment (Mi Sphere Takes the Cake)

What have I learned about 360 cameras? 

For one, the Gear 360 was trendy and cool when it came out. Alas, its time has passed. The new affordable alternative is the Mi Sphere, created and shipped by Xiaomi from China. The best thing about this 360 camera, is that they do not have copyright limitations in China. Xiaomi has ripped off all the great features of a dual lens 360 camera. The still shot resolution is large enough to create beautiful virtual tours. So after playing with the Gear360 I returned it to Amazon. The best part about that camera was the iPhone and Mac compatibility. The Mac Desktop Application is supposedly coming for the Mi Sphere, so I shall wait. 

Continue Reading

In the meantime, the PC desktop application works. I am a little disappointed the Gear360 software was not compatible with my new device. The Xiaomi Mi Sphere PC software is tiny on my high res screen, thus I need to use the magnifier to see what is going on. However, it does stitch the images/video together quite nicely. I will be making Virtual tours in no time. ^_^

At this time I am packing up my things, and moving to a new place. This means I will have 2 empty homes to photograph and experiment with for my new hobby. I wont have a product until November, but when the time comes to share it I will be able to host these tours on my website with a word press plugin, I am considering “iPanorama” or “WP Virtual Tours” … I pay for a hosing service that I am not truly using. My dream is to add another domain to my hosting and sell links to realtors, The guests will be navigated to my alt domain and get to interact with potential homes as much as they would like. 

Very excite!

ThreeSixtyCameras Comparison: Gear 360 vs Mi Sphere

Many Thanks to Ben from “Life in 360” on Youtube, check out his review on the Xiaomi Mi Sphere 360 camera: 

Finished Reading

Virtual Tour Programs for WordPress

iPanorama is a program I’d love to experiment with. I would like to learn how to use programs that can create virtual tours with 360 degree panoramas (and have WordPress compatibility). I wonder … what is it the perfect tool for me to build virtual tours? What can it do? What else is important to include? What else do I need to make an efficient tour? 

Continue Reading

Short Code: ipanorama id= “3224” width= “100%” height= “240px”


I might also try the WP Virtual Tour plugin for WordPress, it shows how the portals work as hot spots, that is essential functionality for my tours.

I also found a pano embed tool for WordPress, but you would need one of those $$$ programs to create your tours first. 

Finished Reading

VR and Real Estate

Recently I have been looking through postings on Zillow.com and other Real Estate websites to look at home listings in my town and what they are selling for. It’s interesting at this time not many listings include video or virtual walkthroughs. New Virtual Tour technology has not effected the realtors in my area yet, and this technology is here. My goal is to figure out how to make beautiful virtual tours, and market them to people who are really making money. Starting with my neighborhood Realtor! 

Continue Reading

What will be involved?

  1. First I need a 360 degree camera, I picked the Gear 360 (2017) video camera. 
  2. Then I need a program to edit and publish virtual tours, I’ll try iPanorama for now. I choose this program because it is a WordPress plugin that has been tested with my current version on WordPress. It seems like everything I need for $25.
  3. $250 later I will have everything needed for a DIY Virtual Tour. I can’t wait!

First I will need to install the memory card, possibly charge the battery of the device. I’ve already downloaded the app for my iPhone 7. Then I will need to find a tripod that is minimalistic. I’ll go to an open space and experiment. Once I have some footage I’ll play with my demo of iPanorama. Once I create a few 360 degree panorama views I will try to add hotspots or portals that will navigate you from one center image to the next just by clicking. Lots of these programs offer free trials with watermarks. Which isn’t what I want for my finished product but it is great for experimenting with what is possible. I hope to investigate the possibility of voice over, logos, ect. Thanks to iPanorama I have a way to embed them on my website if all goes well. Further down the line I might consider a tour hosing site like “TourBuzz.” This is a program that is marketed toward Real Estate Agents. It costs $15 a tour and it is extremely shareable and includes all the bells and whistles important to the target audiences (the Seller, Potential Buyers and the Relator). 

What are companies charging for tours? 

  • 3000 sqft = $200-$500
  • 2br=100 euros

What is out there as far as virtual tour companies? What is a fair price to charge clients? Top 11 Most Innovative Real Estate Virtual Tour Companies

11. Our first contestant is OpenHouse charging a monthly rate. $30/mo and a staging fee of $60 per photo. 

10. Real Tour Vision is next These guys are selling programs that are for a diverse variety of clients. They want $100 for their Real Estate software. 

09. ImagineAHome wins, they are using drones, WOW. They want $100 for 5 Images and $235 for 8 scenes, every extra scene is $20. The portals/hotspots work beautifully, it’s truly a premium virtual tour. 

08. Imagemaker360 offers tours and web hosting for tours a business would sell to their clients. It really polishes all of the issues a realtor might have with virtual tours. 

07. Houssmax is expensive, but they have an algorithm that lets you figure out what your tour would cost. My example was a townhome less than 2500-3000sqft estimated price $300. This includes 30 still shots and 120 sec of video. They will charge $0.17/sqft for anything over 3000sqft (until you get to the next price range.) They are marketing to get everything a potential buyer would want to know. 

06. BlueLaVaMedia pricing starting at $125 for their basic package and up to $250 for the full house package. 

05. Planitar brings the consumer an “iGuide,” this pricing example is for a company in Arizona. They want $50 a tour, or $50 a month. They include all the bells and whistles. 

04. 3DScanExperts are hardcore, they are making tours for VR headsets. This experience is full submersion, it feels like you are at a showing. They still want $500 for a home with 2000-4000 sqft. 

The rest of these are the big fish in the sea, the professionals $$$$: ADhocStudioStartVR, and Floored.

Ok, so now I’ve browsed through what the Pros are doing. I will need to do a test run before I can decide on a fee that would make virtual tours worth my time and overall investment.  It seems like $100 a tour would be a great price, and maybe I could add logos, voice overs and blue prints for extra fees. I will ponder these questions for now. 

Live, Love & Inspire!

Finished Reading

Fiber Optic Dress Cover

Featured Artwork
Fiber Optic Dress Cover | Fiber Optic Whip and Mesh Top | 2015

Fiber Optic Dress Cover | Fiber Optic Whip and Mesh Top | 2015

Natalina’s Fiber Optic Dress on Instructables has inspired me for a long time now, and I feel blessed to have finally purchased a fiber optic whip from Ants on Melon to create a similar outfit. Thank you so much for the inspiration Natalina, I wouldn’t have thought of such a project without your instructable! ^_^

I decided that I wanted to create a garment that would allow for change and ultimately layers. So I ran with Natalina’s idea and …

Continue Reading

bought a netted stretchy top from China. Unfortunately by the time it got to me the concert was already upon us. So I followed your pattern with the fiber optic placement for the time being. It was the months after the show that I chose to refine the dress cover and really put some time into the project, like I originally dreamed of. I ended up restringing all of the strands in groups of two. Tracing my figure with some strands and following the given pattern with the others. It was time consuming, but I would say very much worth the monotony in the end.

This design does not include a zipper. I cut down the front of the mesh and sewed the edges so they would not fray. I tied it together with a stretchy string. The shirt it self was designed to be baggie throughout the netting and tight along the waist. Once the fiber optics were woven in pulling on the strands would create a form fitting top, without the use of a corset or boning. I also bought a cheap tutu and inflated the poof with a thick layer of foam to really get the lights away from my center. Though it does look more elegant in Natalina’s tutorial, my design was supposed to be a more festive and comfortable rendition. I must say I am pleased with the material and the overall functionality of this Fiber Optic Dress Cover.

My next step is to focus on a way to use a 3.7V battery pack with the led flashlight for my optic whip, to boost the power and over all charge of the device. This part should be a challenge for me. However, I hope to use an electrical wire, soldering equipment and a power supply that is easier to get to than directly behind me. I hope to create a more elegant design for my wedding dress when the time comes. Thanks for introducing me to such a magical medium and for the wonderful inspiration!

Finished Reading

Clear Cache Instructions

Clear Cache Instructions for 3 common browsers and operating systems:

Internet Explorer 9-11 or Firefox w/ Windows 7, and Safari with Yosemite.

Continue Reading

Internet Explorer (9, 10 & 11) & Windows 7

1. Open Internet Explorer and click the gear icon on the top right corner of your window to open your browser settings.
2. Select “Safety” and “Delete Browsing History
3. Select “Temporary Internet Files and Website Files
4. Uncheck all other boxes/ options and click “Delete

Firefox & Windows 7

1. Click the Menu icon on the top right of the browser (This is the icon/button with 3 horizontal bars)
2. Click “History
3. Select “Clear Recent History
4. Time range to clear will have to be “Everything
5. Click the arrow next to Details if it does not show a list
6. Select at the minimum “Browsing and Download History, Form and Search History, Cookies, Cache, and Active Logins
7. Select “Clear Now
8. Once it is done clearing the history, close the browser
9. Open Firefox and try to access your unresponsive webmail page again.

Safari & Yosemite

1. To clear your cache on your Mac running Yosemite go to your menu bar at the top of your screen. Click “Safari” and choose “Clear History & Website Data” from the drop down menu.

Finished Reading

One Drive Tuts

This post was created because I am learning about OneDrive and how it will work on campus for FLC staff and faculty. The following page includes links to tutorials from the Office 356 support page.

Office 365 Tutorials

Office Support Search