Prev: Microsoft Excel
Next: I want to search "if cell a1 start with .. "
From: Stuck on 19 Apr 2010 15:40
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.
From: Luke M on 19 Apr 2010 15:49
Insert a helper column, and input this formula:
=A1&"*"

Copy down as needed. Then do a Copy, Paste Special - Values only onto column
A.

--
Best Regards,

Luke M
"Stuck" <Stuck(a)discussions.microsoft.com> wrote in message
news:1DBDB0A7-5399-4D7B-AC3D-71D4A4EB49CB(a)microsoft.com...
>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.


From: dlw on 19 Apr 2010 15:57
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.

"Stuck" wrote:

> 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.
From: L. Howard Kittle on 19 Apr 2010 17:01
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

"Stuck" <Stuck(a)discussions.microsoft.com> wrote in message
news:1DBDB0A7-5399-4D7B-AC3D-71D4A4EB49CB(a)microsoft.com...
>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.


 | 
Pages: 1
Prev: Microsoft Excel
Next: I want to search "if cell a1 start with .. "