Formula advice

[VBA learner ITG]

Hi all,

I need your help, if possible.

Is there a formula that can rearrange the value of the text string from a cell for example:


Original Value:

4079/LCG330/LC

Required output:

LCG330/4079

Any help is really appreciated.

 

[arthurbr]

Wrong answer by me

 

[RoryA]

You could use:

=MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1)&"/"&LEFT(A1,FIND("/",A1)-1)

for example.

 

[VBA learner ITG]

Hi Rory,

Thank you for your time and advice, I have learnt something new today which I definitely will use again in the future!

You could use:

=MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1)&"/"&LEFT(A1,FIND("/",A1)-1)

for example.

 

[DanteAmor]

I present you another way

=TRIM(MID(SUBSTITUTE(A2,"/",REPT(" ",99)),99,50))&"/"&TRIM(LEFT(SUBSTITUTE(A2,"/",REPT(" ",99)),50))

 

[VBA learner ITG]

Hi Dante,

Thank you for your time, this formula was really useful on another query i got stuck on!

I present you another way

=TRIM(MID(SUBSTITUTE(A2,"/",REPT(" ",99)),99,50))&"/"&TRIM(LEFT(SUBSTITUTE(A2,"/",REPT(" ",99)),50))

 

[DanteAmor]

Hi Dante,

Thank you for your time, this formula was really useful on another query i got stuck on!

I'm glad if my help is useful for this or any other question.