|Subject:||Pre-pending and post=pending cell data in Excel|
|Posted by:||David Neustadt (dneusta…@vulcancorp.com)|
|Date:||7 Oct 2003|
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
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.