Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 7th 07, 04:43 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 1
Default 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   Report Post  
Old January 7th 07, 04:49 PM posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 594
Default 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   Report Post  
Old January 7th 07, 05:51 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,718
Default 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   Report Post  
Old January 8th 07, 03:06 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default 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   Report Post  
Old January 9th 07, 03:20 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 3
Default 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   Report Post  
Old January 9th 07, 03:20 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 3
Default 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   Report Post  
Old January 9th 07, 03:21 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using an Index by Column Headings instead of Column Numbers Sean Bishop New Users to Excel 2 November 21st 06 09:38 PM
Rearrange numbers from a column in a different order in a second c Gaetan58 Excel Discussion (Misc queries) 14 November 21st 06 07:43 AM
Completely baffled on what should be simple Pat Hughes Excel Discussion (Misc queries) 12 October 23rd 06 08:24 PM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017