convert number to number in excel

[bogd1n]

hello
tks for help me

EXCEL QUIESTION.jpg

my problem is describes up

[FDibbins]

Hi, welcome to the forum

I have NO idea what you want here

Please describe in words, what you are doing, and Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[bogd1n]

prblem is this

i have in column A a name johnn, peter, sergio; in colomn b is number p.123456/7 and i want to transform in R37 if in first cell A1 is S and rest of numbers in same 123456 result is R37123456
if i dont have in colomn A letter S RETURN R17123456
i try with left right mid FUNCTION but i dont know how i use for the resultat want to be right

tks

[bogd1n]

nobody have a idea?

[sourabhg98]

Try this
=IFERROR(IF(LEFT(A1)="S","R37","R17")&MID(B1,FIND(".",B1)+1,FIND("/",B1)-FIND(".",B1)-1),"")

[bogd1n]

TEST.jpg

it is good but not enough

thanks man

[bogd1n]

any sugestion?

[protonLeah]

You really need to post a sample workbook so members don't have to recreate new ones from those pictures. Also, in post #5 you should explain why it's wrong or not enough.

[sourabhg98]

Try this one
="R"&IF(LEFT(A1)="S",30,10)+(RIGHT(B1,LEN(B1)-FIND("/",B1))+0)&MID(B1,FIND(".",B1)+1,FIND("/",B1)-FIND(".",B1)-1)

Next time upload a sample workbook instead of pictures to understand the problem better...
You can upload a workbook--
1. While starting a new thread-- by clicking on the paper clip icon from the icons above
2. While replying--by clicking on go advanced button and then selecting the paper clip icon from icons above..

[bogd1n]

TEST.xlsx

hello again

[QUOTE=sourabhg98;4009446]Try this one
="R"&IF(LEFT(A1)="S",30,10)+(RIGHT(B1,LEN(B1)-FIND("/",B1))+0)&MID(B1,FIND(".",B1)+1,FIND("/",B1)-FIND(".",B1)-1)
tks man , you are a great man

i try this formula is very good if i have " /1" or "/xx" but if don't have excel give me a error (p.123456/1 is good formula) (p.123456 isn't good )
i delevop a formula but i want same formula for all colummn i not want to have two formulas

tks again