How to change the arrangement of text in a cell

**Starbucks Junkie** · 06-10-2009, 12:09 PM

Guys,

I wonder if you can assist me;

I have a range of cells that have text formatted in the following way;

Ancillary (900)BABY (300)BATTERIES (100)CELEBRATIONS (550)CLOTHING (700)DIY (600)ENTERTAINMENT (150)FOOD & DRINK (850)GARDENING (450)HEALTH & BEAUTY (200)HOMEWARES (400)HOUSEHOLD (350)PET (650)SEASONAL/EVENTS (480)STATIONERY (750)TOYS (800)XMAS (500)

I need to change the arrangement of the cells so that the Brackets and numbers appear in the cell before the text, how can I achieve that?

Poor example but each cell will only contain one of the above variants, not all of the variants.

Any help is most welcome and appreciated.

**Special-K** · 06-10-2009, 12:14 PM

How about use Text to columns with ")" as a delimiter character
Once the data is in columns concatenate the numbers with ")" to put the bracket back

**NBVC** · 06-10-2009, 12:23 PM

Or with formula:

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

**adfeddon** · 05-23-2013, 03:55 PM

Ok, is there a way to change this within the same cell?

Example:

1800 (70.87")
to
70.87 (1800)

**adfeddon** · 05-23-2013, 04:06 PM

I can do this with text to columns and find/replace but I was hoping for a formula to expedite. Thanks!

**arlu1201** · 05-24-2013, 07:58 AM

adfeddon,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.