Pre-pending and post=pending cell data in Excel

  • Thread starter Thread starter David Neustadt
  • Start date Start date
D

David Neustadt

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*
 
Do you have to have the asterisks in the cell or can it just look like they're
there.

If your data is really numbers, you could use a custom fromat of:

\*#\*

The asterisks aren't really in the cell, they just look like it. On the other
hand, the value is still a number, so you can do arithmetic with it.
 
Back
Top