Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Zach
 
Posts: n/a
Default 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   Report Post  
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Zach
 
Posts: n/a
Default

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
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
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Putting text in a column based on variable text from another colum Jacky D. Excel Discussion (Misc queries) 1 December 16th 04 07:09 PM
Is there a way I can enter a letter to proceed text a column of ce Gordon Excel Discussion (Misc queries) 3 December 13th 04 08:13 PM


All times are GMT +1. The time now is 09:53 AM.

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

About Us

"It's about Microsoft Excel"