In Excel how can I add symbol to entire column?

S

singmusik04

I downloaded a list of songs for a karaoke book. Column 1-Song Title Column
2-Artist Column 3-Disc Number Column 4-Song Number.

I would like to add a "-" symbol to the ENTIRE column 4. There are 1,000
songs and I would hate to go through EVERY single number and place a dash
before the number.

In other words, as is, it would look like this: "Respect Franklin,
Arethra 63 9" I would like it to look like this "Respect Franklin,
Arethra 63-9" Thank you.
 
T

Toppers

Put -1 (minus one) in a cell and copy (the cell)

highlight column 4

Paste Special=>Operation=>Multiply

Delete -1 from your cell.
 
G

Gary''s Student

Select column D (the entire column) and then:

Edit > Replace and enter a space in the replace what field and a dash in the
replace with field and then replace all
 
T

T. Valko

Here's a short macro that will do this:

Sub AddDash()

Dim cell As Range
For Each cell In Selection
If cell.Value <> "" Then
cell.Value = "-" & cell.Value
Else: cell.Value = cell.Value
End If

Next cell

End Sub

To install the macro
Hit ALT F11 to open the VBE
Hit CTRL R to open the Project Explorer
Right click on your file name
Select Insert>Module
Paste the macro code into the window that opens on the right
Hit ALT Q to return to Excel
Select the range of song numbers in column 4 then run the macro.

Biff
 
S

singmusik04

you are a genius thank you!!!!

Toppers said:
Put -1 (minus one) in a cell and copy (the cell)

highlight column 4

Paste Special=>Operation=>Multiply

Delete -1 from your cell.
 

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