LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 504
Default How do I automate bracketing of text in an Excel cell?

I have a column of text that all begin and end with a bracket ([]). The text
varies, but the start and finish should all show brackets. How do I automate
the entry of this after all the text is entered. I tried to create a macro by
typing the first bracket, then entering the "end" key and typing the end
bracket. That routine copied all the text between the brackets, as well as
the brackets. Any ideas?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel---how do i automate adding a suffix to text? Peter-NYC Excel Discussion (Misc queries) 1 January 29th 08 05:21 PM
Automate adding in a reference number if the adjacent cell contains text... mg[_2_] Excel Worksheet Functions 1 January 24th 08 01:16 AM
Double quotes bracketing text strings that include commas ExcelStudent Excel Discussion (Misc queries) 1 August 2nd 07 12:48 PM
8 team bracketing sheet Ryan Schwartz Excel Discussion (Misc queries) 1 February 13th 07 05:40 PM
Excel - Automate row width for merged cells with wrapped text Sweetiedaw Setting up and Configuration of Excel 0 September 7th 06 10:23 PM


All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"