| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
add alpha letter to column of numbers
I have a column of part numbers that I want to re-identify with a "W" in
front of the number. There has to be a quick way of doing this but everything I have tried fails. Any advice?? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
add alpha letter to column of numbers
One way is to CONCATENATE.........using a helper column, say column B, put
this in B1 and copy down ="W"&A1 Then do copy PasteSpecial Values on Column B to remove the formulas........then delete column A if you wish...... It can also be done with VBA code, without using a helper column, if that method is of interest....... Vaya con Dios, Chuck, CABGx3 "-John W." <-John wrote in message ... I have a column of part numbers that I want to re-identify with a "W" in front of the number. There has to be a quick way of doing this but everything I have tried fails. Any advice?? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
add alpha letter to column of numbers
Custom Format:
"W"0 "-John W." wrote: I have a column of part numbers that I want to re-identify with a "W" in front of the number. There has to be a quick way of doing this but everything I have tried fails. Any advice?? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
add alpha letter to column of numbers
Here's a simple macro:
Sub AddW() Dim cell As Range For Each cell In Selection If cell.Value < "" Then cell.Value = "W" & cell.Value Else: cell.Value = cell.Value End If Next cell End Sub Select the range of part numbers then run the macro. Biff "-John W." <-John wrote in message ... I have a column of part numbers that I want to re-identify with a "W" in front of the number. There has to be a quick way of doing this but everything I have tried fails. Any advice?? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
add alpha letter to column of numbers
Thanks!!!
"-John W." wrote: I have a column of part numbers that I want to re-identify with a "W" in front of the number. There has to be a quick way of doing this but everything I have tried fails. Any advice?? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
add alpha letter to column of numbers
Thanks!!
"Teethless mama" wrote: Custom Format: "W"0 "-John W." wrote: I have a column of part numbers that I want to re-identify with a "W" in front of the number. There has to be a quick way of doing this but everything I have tried fails. Any advice?? |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
add alpha letter to column of numbers
Thanks!!
"T. Valko" wrote: Here's a simple macro: Sub AddW() Dim cell As Range For Each cell In Selection If cell.Value < "" Then cell.Value = "W" & cell.Value Else: cell.Value = cell.Value End If Next cell End Sub Select the range of part numbers then run the macro. Biff "-John W." <-John wrote in message ... I have a column of part numbers that I want to re-identify with a "W" in front of the number. There has to be a quick way of doing this but everything I have tried fails. Any advice?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an Index by Column Headings instead of Column Numbers | New Users to Excel | |||
| Rearrange numbers from a column in a different order in a second c | Excel Discussion (Misc queries) | |||
| Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
Linear Mode
