Flipping a cell content in Excel 2007

[blackystrat]

Hello

How can I flip the content of a cell in Excel 2007

For example:-

I want to have Trim Motors : Electrical System : Honda Outboard as Honda Outboard : Electrical System : Trim Motors

I have thousands of cells with data in this order that I need to reverse/ flip.

Please advise

Thanks a lot

 

[VBA Geek]

you could do it with a formula, but a UDF makes it much easier

Function REVERSE_CELL(strIn As String, _
                        Delim As String) As String
    Dim Ndx As Long, A As Variant, strOut As String
    A = Split(strIn, Delim)
    For Ndx = UBound(A) To LBound(A) Step -1
        strOut = strOut & A(Ndx) & Delim
    Next Ndx
    REVERSE_CELL = Left(strOut, Len(strOut) - Len(Delim))
End Function

<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B1</th><td style="text-align:left">=REVERSE_CELL(<font color="Blue">A1," : "</font>)</td></tr></tbody></table></td></tr></table><br />

Excel 2013
	A	B
1	Trim Motors : Electrical System : Honda Outboard	Honda Outboard : Electrical System : Trim Motors
Sheet1

 

[blackystrat]

Thanks for the help but it's not working.

I tried it but it's giving a #NAME? error

FYI, I am trying this on Excel 2007, not sure if that matters.

Please advise

 

[VBA Geek]

before applying the formula on the worksheet, you need to press ALT+F11, you will see VB editor, at the top you will see INSERT, choose INSERT MODULE, paste my code in there then go back to excel and apply the formula again

 

[blackystrat]

Works perfect now

Thanks a bunch