Poundland
06-10-2009, 09:06 AM
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.
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.