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*
 
David:

you can do the following

Range("a2")= "*" & range("a2") & "*"

assume that the first row of data is in row a2
you will have to go over all cell to do the change.

Andres
 
See one other guess at your other post.


David said:
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*
Click to expand...
 
Back
Top