Add letter to a group of cells

blueclip

New Member
Joined
Aug 25, 2002
Messages
1
Hi:
Anyone here knows how to add a letter to a group of cells without having to add it manually one by one? For example, I need to add an "A" to every cell in Column B. Since there are about 3,300 rows, I'd have to spend a lifetime adding that letter to each cell in that column. Any ideas??? Please help!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Or, this might do it:

1) Press Alt + F11 to get the VBA editor
2) Insert this code in the ThisWorkbook area<pre>

Sub AddA()
For Each cell In Selection.Cells
cell.Value = "A" & cell.Value
Next
End Sub</pre>


3) select the cells in question
4) Run the AddA macro from the tolls | macro menu.

Paddy

EDIT: This functionality is also available in the asap addin (which is free!):

http://www.asap-utilities.com

Once installed, it's under the text menu
This message was edited by PaddyD on 2002-08-26 18:42
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top