Formula to change part of a cell string ?

[zillah]

Dear folk

Dear folk

I am doing a labeling for an equipment if I want to change the first cell content for the below example to be say : Linksys.G001.F04.11,,,,,I need cell 5 to be G001.F04

And If I want to change content of first cell to be say : HP.G0AB.R01.18,,,,,,I need cell 5 to be G0AB.R01,,,,,,,etc

Linksys.R000.F03.10
EARTH CHASSIS
TO
RACK EARTH
R000.F03
PII234567

What formula do I need to do so ?

Thx

[Sam Capricci]

If it is in the same place and the same length each time you could use a mid formula, something like...
=mid(A1,8,8) untested it could be 8,9 or 9,8, writing from an iPad isn’t easy.

[zillah]

Thx for your help
idea is clear and it worked for me

[zillah]

same place and the same length each time

Same place yes what about if it is not the same length ?

[Sam Capricci]

Check the yellow banner at the top of the post, it would be best if you would upload a sample workbook that shows the different examples you would have and your expected results. Because now you’re probably going to have to incorporate a search function in the formula.

[zillah]

Thx Excel sheet that has samples uploaded
You did explain sample 1 can you help with sample 2 and sample 3 in the attached excel sheet t

[Sam Capricci]

this works for the three examples you put in your workbook... =MID(E27,FIND(".",E27)+1,8)

[zillah]

Thx Sam
It worked for Sample 1 and Sample 2 but not 3
Can you please recheck it
Regards

[Sam Capricci]

what is your expected output for sample 3? If it is R000.F03 it returns that.

[zillah]

Sample 1 and 2 no issue

Sample 3 I should have explained in better way sorry for the confusion
I am looking to change only the highlighted text in bold red

[Sam Capricci]

I'm uploading your workbook with the formula in cells G31, K31 and O31 (which is the output for Sample3) and it appears to be returning the portion you have in bold red. So again I ask, what is the expected output if what is in cell O31 is not what you expect?

[zillah]

So again I ask, what is the expected output if what is in cell O31 is not what you expect?

Expected output in O31 is

PDU.R000.F03.33

[Sam Capricci]

I don't know how to make the formula suddenly know to add the PDU. and the .33
what circumstances would there be that could be written into a formula so it knows that under "this" circumstance you add the PDU. and the .33?
is it that if cell M27 has C54. on the left it should add PDU. to the output? Is it that if cell M28 has A FEED -VE it should add the PDU. and the .33?

[zillah]

You are right you don't need to add PDU. and .33

Please see new sample in the attached workbook

[Sam Capricci]

try this... ="PDU."&MID(M27,FIND(".",M27)+1,8)&".33"

[zillah]

Thx for that ,,,appreciate your help