Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding extra text into an existing column
right now i have a column which lists drawing numbers (11549974) and such. i
want to just add "SH1" to the end of each drawing number. in the column, there are several hundred listed. what code do i need to add the SH1 onto the end without changing the existing number? ex. 11579974 --- 11579974 SH1 |
#2
|
|||
|
|||
Use a custom format, Zach. Format--Cells, choose the Number tab, then
Custom. Type the following into the box at top-right: 00000000" SH1" ************ Anne Troy www.OfficeArticles.com "Zach" wrote in message ... right now i have a column which lists drawing numbers (11549974) and such. i want to just add "SH1" to the end of each drawing number. in the column, there are several hundred listed. what code do i need to add the SH1 onto the end without changing the existing number? ex. 11579974 --- 11579974 SH1 |
#3
|
|||
|
|||
Anne than you SO much. You just saved me several hours of work. I would
have otherwise had to go through and enter them by hand, one by one. Now to fill the rest of my hours... "Anne Troy" wrote: Use a custom format, Zach. Format--Cells, choose the Number tab, then Custom. Type the following into the box at top-right: 00000000" SH1" ************ Anne Troy www.OfficeArticles.com "Zach" wrote in message ... right now i have a column which lists drawing numbers (11549974) and such. i want to just add "SH1" to the end of each drawing number. in the column, there are several hundred listed. what code do i need to add the SH1 onto the end without changing the existing number? ex. 11579974 --- 11579974 SH1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Is there a way I can enter a letter to proceed text a column of ce | Excel Discussion (Misc queries) |