Hi Alex, Please find attached the solution. I have used the following code inside a module Sub village()
' This loop runs until there is nothing in the last cell
' Aindril De (Andy)
Do
ActiveCell.Value = "[village]" & ActiveCell.Value & "[/village]"
ActiveCell.Offset(1, 0).Select
Loop Until IsEmpty(ActiveCell)
End Sub
*To run this code. click on the first cell where you want to start the
changes (in my example it is cell B2) and then click on the button named
village.*
Pl let me know if u need any further help on this.
Cheers!!,
Andy
On Tue, Jul 6, 2010 at 8:11 PM, Alexander Cargill <
zanderman1...@googlemail.com> wrote:
>
>
>
>
> Hi All I was wondering if you could help. I have a column of data which is
> Column B within a sheet that I wish to alter, the data has the following
> format : XXX|XXX and I wish to change the contents of the cells in the
> column from XXX|XXX to [village]XXX|XXX[/village] using a single button. So
> essentially I want to add the text [village] before the co-ords and the text
> [/village] after the co-ords in each cell in column B can anyone help??
>
>
>
> Thanks very much Alex
>
>
>
> Ps I can supply the sheet if needed J
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Alexander.xls
Description: MS-Excel spreadsheet
