### How JustAnswer Works:

• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee

## Ask The-PC-Guy Your Own Question

The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1871
Experience:  Extensive Knowledge in PHP, MYSQL, CSS & Javascript
62934938
Type Your Programming Question Here...
The-PC-Guy is online now

# I have some cells with the format for example: SS4567 and some

### Resolved Question:

I have some cells with the format for example: SS4567 and some with the format: SX64. I need to retain the letters and the two numbers if that is all it has but if it has four, I need the first and third - so the first example would be converted to SS46.
Any ideas?
Submitted: 2 years ago.
Category: Programming
Expert:  The-PC-Guy replied 2 years ago.
The-PC-Guy :

My Name is***** will be helping you today. If I provide good service, you may ask for The-PC-Guy in your question title for your future needs.

The-PC-Guy :

is this in excel?

The-PC-Guy :

hello

The-PC-Guy :

is this in excel?

Expert:  The-PC-Guy replied 2 years ago.
chat does not seam to be workng

is this in excel?
Expert:  The-PC-Guy replied 2 years ago.
ok, assuming this is in excel and assuming that all cells you are using follow the same format, they have 2 lettters and either 2 or 4 numbers. then you would use this formula.

for now I will assume that cell A1 has your first value in it and will go from there.

if it is not in cell A1, just change every value of A1 in the formula to whatever cell you are referring to, and then you can copy it down whatever column you need to.

=IF(LEN(A1)=4,A1,LEFT(A1,2)&MID(A1,3,1)&MID(A1,5,1))

---------------------------------------------------------------------------------------------------------------

let me know if you have any questions, problems, or concerns

PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION

TO RATE, CLICK THE SMILEY FACES BENEATH THIS ANSWER

Do not rate negatively, instead continue the conversation with me so I can address any of your concerns

---------------------------------------------------------------------------------------------------------------

if you have any questions in the future you can visit my profile

http://www.justanswer.com/computer/expert-1expert-2rulethemall/

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.
Customer: replied 2 years ago.

Hi,

This seems to return 0 in all cases

Any other ideas?

Cheers

Stella

Expert:  The-PC-Guy replied 2 years ago.
can you send me an example sheet?
Expert:  The-PC-Guy replied 2 years ago.
also you may want to check the cell format of the target cell, make sure it is "general"
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1871
Experience: Extensive Knowledge in PHP, MYSQL, CSS & Javascript
The-PC-Guy and 2 other Programming Specialists are ready to help you
Customer: replied 2 years ago.

Genius!

Very many thanks

Stella

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• ### ATLPROG

#### Satisfied Customers:

7260
MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Previous | Next >
• http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

### ATLPROG

#### Satisfied Customers:

7260
MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
• http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

### LogicPro

#### Satisfied Customers:

5514
Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
• http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

### lifesaver

#### Satisfied Customers:

936
Several years of intensive programming and application development experience in various platforms.
• http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

### ehabtutor

#### Satisfied Customers:

766
Bachelor of computer science, 5+ years experience in software development, software company owner
• http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

### Eljon

#### Satisfied Customers:

558
Founder of StockCanvas.com
• http://ww2.justanswer.com/uploads/FA/fael/2011-1-15_104041_profile500x500.64x64.jpg Rafael Martins's Avatar

### Rafael Martins

#### Satisfied Customers:

446
Desktop, Mobile and Web Developer. 7+ years of experience. Creative solutions provider.
• http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

### The-PC-Guy

#### Satisfied Customers:

320
Extensive Knowledge in PHP, MYSQL, CSS & Javascript