LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tiziano
 
Posts: n/a
Default Modification of Part Number (Revised)

I would like to add the string "1212" (no quotes) to some part numbers.

Essentially, I have two versions of part numbers to modify:
xxxxxxx(space)(space)xxxxxxxxxx(space)xxxxx(space) xxxx
or
xxxxxxxxxx(space)xxxxx(space)(space)xxxxxxx(space) xxxx(space)xxxx

The length of the xxxxxx strings varies and represents alphanumeric
characters that must remain unchanged. The string "1212" (no quotes) must
always be appended to the first xxxxx string of alphanumeric characters.

Thus the end result of the modification should be as follows:
xxxxxxx1212(space)(space)xxxxxxxxxx(space)xxxxx(sp ace)xxxx
or
xxxxxxxxxx1212(space)xxxxx(space)(space)xxxxxxx(sp ace)xxxx(space)xxxx

All the part numbers that I want to modify will be listed in Column A of my
spreadsheet. (There are other part numbers in other columns but I do not
want to modify them.)

Would somebody please suggest how to do it? This is beyond my knowledge of
Excel.

Thanks in advance.
----
Tiziano


 
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
Modification of Part Numbers Tiziano Excel Discussion (Misc queries) 3 February 26th 05 06:32 PM
Part Number/Qty Consolidations [email protected] Excel Discussion (Misc queries) 2 February 6th 05 09:21 PM
need check two worksheets to lookup a value Clay Excel Discussion (Misc queries) 2 January 5th 05 08:35 AM
Defining a number in a cell by text then subtracting it by the tex Crowraine Excel Worksheet Functions 1 December 16th 04 07:49 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 03:56 AM.

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

About Us

"It's about Microsoft Excel"