software

I have a column with license numbers in them. I have about 2000 rows in this
column. I need to insert a ; (semicolon) at the end of each license number.
Is there a way I can do this without having to go through all 2000 rows?
Thanks.

In a staging column, enter formula
=A1amp;quot;;quot;
and copy it down 2000 rows

Select the staging row
Copy
Select A1
Paste Special Values

HTH
--
AP

quot;CJquot; gt; a écrit dans le message de
...
gt; I have a column with license numbers in them. I have about 2000 rows in
this
gt; column. I need to insert a ; (semicolon) at the end of each license
number.
gt; Is there a way I can do this without having to go through all 2000 rows?
gt; Thanks.
If the license numbers are in column A, select column B and Insert gt; Column.
Then, in B1 enter the formula =A1 amp; quot;;quot;. Autofill that formula through all
rows of column B. Then select column B and Edit gt; Copy, then Edit gt; Paste
Special, select the Values radio button and click OK. If everything looks
okay, you can delete column A and you'll have effectively appeneded a
semicolon to each of the license numbers in column A. (If you may ever need
the old version w/o the ; you should probably skip the delete step and keep
both columns).

quot;CJquot; wrote:

gt; I have a column with license numbers in them. I have about 2000 rows in this
gt; column. I need to insert a ; (semicolon) at the end of each license number.
gt; Is there a way I can do this without having to go through all 2000 rows?
gt; Thanks.

try
Sub addsemicolontoend()
For Each c In Selection
c.NumberFormat = quot;@quot;
If Len(c) gt; 1 And IsNumeric(c) Then c.Value = c amp; quot;:quot;
Next
End Sub

--
Don Guillett
SalesAid Software

quot;CJquot; gt; wrote in message
...
gt;I have a column with license numbers in them. I have about 2000 rows in
gt;this
gt; column. I need to insert a ; (semicolon) at the end of each license
gt; number.
gt; Is there a way I can do this without having to go through all 2000 rows?
gt; Thanks.
I would also go to menu gt; format gt; cells gt; custom gt; type 0quot;;quot; then use
format painter to copy the same thru the 2000 rows

quot;elephantquot; wrote:

gt; I would also go to menu gt; format gt; cells gt; custom gt; type 0quot;;quot; then use
gt; format painter to copy the same thru the 2000 rows
gt;
gt;

Thanks for this. The others above helped me out with the general changes but
then I couldn't figure out how to do dates because it would change it to a
general format and the date would change to a 5 digit number but this fixed
that. Thanks again.