Threadless

ferfo
ferfo aka fernando is a 19.54 year old boy, has been a member since September 28, 2008, has scored 6,660 submissions, giving an average score of 2.74, helping 113 designs get printed.
Ok so, I have a series of product numbers that go somewhat like this

2178QL9765

The letters in the middle correspond to the warehouse and department, respectively. What I need is some way to extract those letters into a new cell, like this

ITEM------------------WAREHOUSE-------DEPARTMENT
2178QL9765--------------Q---------------------------L
2178nA9765---------------n---------------------------A

I can't think of a way to do it other than with 10 =Substitute functions, substituting all the numbers for blank space. Is there any other way?
Doesn't the 80% of blogs on front page being "PROMOTE YOUR STUFF" blogs defy their purpose?
I wanted to do a design but just noticed I'd have to do 4 to keep all rows even, and that's a bit much, so.
Hi.
Threadversary coming up in two days, so figured I'd come back and try to stay active.

hi :B
What are your opinions on it?
Most people here, including some political figures, are asking for it to be approved due to some idiotic gangsters setting a bus on fire, killing everyone inside. People are asking for them to be prosecuted as terrorists.
Me? I'm indifferent, but I'm still intrigued to hear different opinions.
I just spent like 10 minutes getting results that in no way comply to what I was looking for, only to see in tiny font at the bottom such idiotic "help" as:

Tip: These results include the word "dissent"

Tip: These results include words similar to the words in your search. Show results that include the exact words in your search.
seriously? I've run out of things to do
How do you occupy a lazy afternoon?

Also, interesting reads/articles are superior to flash games.
FUCK YESSSSSSSSSSSSSSSSSSSS
We all have shitty bands that make us ashamed when they show up on shuffle when someone else is listening, so let's hear them







Subscribe to an RSS feed for this blog

Check out the archive for a list of all posts

My gallery photos

I haven't submitted any photos. I guess I don't want free money.

My designs


All about me