Hello, I am trying to create a copy-able and paste-able string of information, and I'm not sure whether Excel is the right application to be using.
I am attempting to create a string of information that needs to copied, then pasted into a Craigslist ad. Here is what my need is, specifically.
When trying to list Automobile tires, there is a standard format that the size of the tire follows, but since most people do not adhere to this rule, I need to create a line that
is a TAGS line at the bottom of the ad, so that if someone enters a search term into Craigs, using characters or spaces other than the correct way, I can capture that viewer and appear in his search results.
Here is an example:
I want to sell a tire, it's size is P225/60R16. Someone may search for this size as 225-60-16, or P225/60-16, or 225/60R16, or a host of other possibilities. I have thought of 19 different ways of entries that I would like to enter under the "Tags:" line.
Is there a sheet I can build where I have perhaps 3 cells, let's say A1 is the letter P and three spaces(for the first numbers 225), A2 is 2 spaces (for the numbers 60), and A3 is 2 spaces (for the numbers 16). Entries made into those 3 cells would also populate, or copy themselves, into 19 other cells that contain the variable entries that need to be copied then pasted into Craigslist, separated by commas. This sheet would be used to help create that "tags" line when I input different size tires into the first 3 cells, or whatever cell combination you think might work.
This is an example of what my tags line on Craigs looks like:
"Tags:"P225/60R16,225/60/R16,225/60/16,P225/60/16,P225/60/R16,P225/60-R16,P225/60-16,225/60-R16,225/60-16,P225-60R16,P225-60-R16,P225-60-16,225-60R16,225-60-16,P225 60 R16,P225 60R16,P225 60 16,225 60 16,225 60 R16.
The sheet would be used to enter the 3 different sets of numbers, like instead of 225-60-16, maybe the tire is 275-45-20, and so on.
Thanks for any insight or guidance you might be able to shed on this.....even if Excel could accept the entries, would it be able to be copied and pasted into a single line? I don't mind doing some of the extra work like separating the string and entering the commas,etc.
Thanks again, Joe
Bookmarks