Thanks, that works well but is not pratical for us. All columns are being
used out to column AE. To have the users go out beyond AE to enter the text
and then move back to the range near column H will greatly effect production,
negatively. THey would have the bullets, but data entry would be to slow to
accomadate the high volume required by our operation.
I am still searching for a coding method that a beginner in VBA can implement.

"J_Knowles" wrote:

If you want a formula, you can place a bullet in column H by using the
char(149) for a bullet symbol and concatenate some text.

cell H1 =CHAR(149) &" "&G1

substitue your cell reference for G1

HTH
--
Data Hog


"Marsh" wrote:

Good Morning,
A group of 22 users have asked if it possibe to insert bullets into text
entries in a column, for example column H. Inserting a Symbol is not
convenient. I did a search and found the following answer to this question
back in Feb 2006,
A simple code line

Set TB = UserForm1.TextBox1
TB.Value= Replace(TB.Value, CHR$(10), "* ")

should do the trick.
I am not a programmer. Could someone please let me know how I can implement
this into our file
THank you
Marsh