how can I add an * to be the last character in a cell

  • Thread starter Thread starter Stuck
  • Start date Start date
S

Stuck

I have 4,000 rows with data, and now realize I need an * to be the last
character in all of the cells in Column A. Please help.
 
Insert a helper column, and input this formula:
=A1&"*"

Copy down as needed. Then do a Copy, Paste Special - Values only onto column
A.
 
insert a "helper" column next to A. (it should be column B) in B1 enter
=a1&"*" and copy it down. Then copy/paste special to turn the column into
values.
 
You could run this lil macro.

Option Explicit

Sub thestar()
Dim c As Range
For Each c In Range("A:A")
If c.Value <> "" Then
c = c.Value & "*"
End If
Next
End Sub

HTH
Regards,
Howard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Find & Replace one cell w/another cell unequal occurrences 3
Sort by last two characters, not the first. 4
text columns in one cell 13
check first 3 characters of a cell and compare to a table 4
How to lookup based in the first 3 characters of a cell 2
# of Characters in a cell 2

Back
Top