Reverse cell contents

**stumann121** · 08-19-2015, 08:27 AM

Hello all,

I am very new and was wondering if anyone can help me please.

I am looking to reverse the contents of a cell.

The list looks like this

AED/AUD
AED/CAD

I would like it to reverse and look like this

AUD/AED
CAD/AED

Thanks for your help.

S

**berlan** · 08-19-2015, 08:29 AM

If applied on cell A1, try;

=RIGHT(A1,3)&"/"&LEFT(A1,3)

**JohnTopley** · 08-19-2015, 08:30 AM

Is it always xxx/yyy or can the text be variable length?

**stumann121** · 08-19-2015, 08:37 AM

Hi Guys,

The formula Berlan gave me worked!

Hi JohnTopley, yes the length is always the same.

Thank you very much for your help.

S

**sktneer** · 08-19-2015, 08:46 AM

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.

**samba_ravi** · 08-19-2015, 08:59 AM

or
=MID(A1&"/"&A1,5,7)

Reverse cell contents

LinkBack

Thread Tools

Rate This Thread

Display

Reverse cell contents

Re: Reverse cell contents

Re: Reverse cell contents

Re: Reverse cell contents

Re: Reverse cell contents

Re: Reverse cell contents

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find Cell that matches based on other cell contents and display adjacent cell contents

[SOLVED] How to Reverse Contents in an Excel cell (Text or a Number)

Reverse Combining Row Contents

Reverse Data In A Cell / Reverse Cell Contents

Reverse the contents of a column by macro

[SOLVED] Using only Excel to reverse the contents of the cell.

How do I make a cell's contents equal to another cell's contents with macro program?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions