Adding a -L at the end of each number within a column

J

Jim S

An example:

2.1.21-L
2.1.22-L
2.1.23-L
2.1.24-L
2.1.25-L

I would like to add -L to the end of each number in the column without doing
the manual process. How can I do this?

2
2.1
2.1.1
2.1.2
2.1.3
2.1.4
2.1.5
2.1.6
2.1.7
2.1.8
2.1.9
2.1.10
2.1.11
2.1.12
2.1.13
2.1.14
2.1.15
2.1.16
2.1.17
2.1.18
2.1.19
2.1.20
2.1.21
2.1.22
2.1.23
2.1.24
2.1.25
2.1.26
2.1.27
2.1.28
2.1.29
2.1.30
2.1.31
2.1.32
2.1.33
2.1.34
2.1.35
2.1.36
2.1.37
2.1.38
2.1.39
2.1.40
2.1.41
2.1.42
2.1.43
2.1.44
2.1.45
2.1.46
2.1.47
2.1.48
2.1.49
2.1.50
2.1.51
2.1.52
2.1.53
2.1.54
2.1.55
2.1.56
2.1.57
2.1.58
2.1.59
2.1.60
2.1.61
2.1.62
2.1.63
2.1.64
2.1.65
2.1.66
2.1.67
2.1.68
2.1.69
2.1.70
2.1.71
2.1.72
2.1.73
2.1.74
2.1.75
2.1.76
2.1.77
2.1.78
2.1.79
2.1.80
2.1.81
2.1.82
2.1.83
2.1.84
2.1.85
2.1.86
2.1.87
2.1.88
2.1.89
2.1.90
2.1.91
2.1.92
2.1.93
2.1.94
2.1.95
2.1.96
2.1.97
2.1.98
2.1.99
2.1.100
2.1.101
 
P

Patrick Molloy

for rw = 2 to range("A1").End(xldown).row
cells(rw,"A").Value = cells(rw,"A").Value & "-L"
next
 
E

EricG

In a blank column, place this formula (assuming your existing data are in
column A, starting in row 2):

=A2&"-L"

Then select all of the cells in the column with the above formula, down to
the end of your data, and select "Edit/Fill/Down" from the menu, or press
Control-D.

HTH,

Eric
 
J

Jacob Skaria

Patrick has given you the code assuming you are familiar with macros.. This
will convert your data in Column A of the active sheet. Launch VBE using
Alt+F11 .From menu Insert a module and paste the code..Make sure you have the
code within the procedure (similar to below). Get back to workbook and trying
running the macro from Tools>Macro>...

Sub Macro()
' paste the code here
End Sub


If this post helps click Yes
 

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

Top