View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Neustadt David Neustadt is offline
external usenet poster
 
Posts: 2
Default Pre-pending and post-pending cell data in Excel

Question:

Is there a VB command or a way in Excel to prepend and postpend data
in an Excel cell.

For example, let's say I have a column with the following numbers

11888
3623
1234

How can I format all the cells in that column so that numbers have an
* at the beginning and at the end? So my results would look like this.

*11888*
*3623*
*1234*