Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a -L at the end of each number within a column
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a -L at the end of each number within a column
for rw = 2 to range("A1").End(xldown).row
cells(rw,"A").Value = cells(rw,"A").Value & "-L" next "Jim S" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a -L at the end of each number within a column
Do i need to put this in a macro or past it in a cell within the column?
Jim "Patrick Molloy" wrote: for rw = 2 to range("A1").End(xldown).row cells(rw,"A").Value = cells(rw,"A").Value & "-L" next "Jim S" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a -L at the end of each number within a column
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 "Jim S" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a -L at the end of each number within a column
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a -L at the end of each number within a column
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 ToolsMacro... Sub Macro() ' paste the code here End Sub If this post helps click Yes --------------- Jacob Skaria "Jim S" wrote: Do i need to put this in a macro or past it in a cell within the column? Jim "Patrick Molloy" wrote: for rw = 2 to range("A1").End(xldown).row cells(rw,"A").Value = cells(rw,"A").Value & "-L" next "Jim S" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding column when number exist | Excel Worksheet Functions | |||
Adding the same number to each cell in a column | New Users to Excel | |||
Adding Row Number to Column | Excel Worksheet Functions | |||
Adding Column Heading w/o Using a Row Number | Excel Discussion (Misc queries) | |||
Adding up number of yes, no, maybes in a column | Excel Worksheet Functions |