Modifying a range of cells
 

I have an imported spreadsheet that I am incorporating into my online store.
It contains about 4500 records. I made a CSV copy to comply with the web
requirements. Now I want to change the contents of some cells.

Example:
Manufacturer part number may be 110-A. I need to change that to KN-110-A.

In other words, I need to add KN- to @4500 part numbers in a column. The
manufacturer part numbers do not always follow a specific format (numbers
only, no hyphens, letters etc.) I know there is a way to do this easily or
relatively easy, I searched the help files but came up empty. Any help?

Modifying a range of cells
 

You can do this with a helper column.

="KN-" & A1

Where A1 is the cell address containing the part number. Or do you want to
do this repeatedly and need a macro?
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"JimJ" wrote:

I have an imported spreadsheet that I am incorporating into my online store.
It contains about 4500 records. I made a CSV copy to comply with the web
requirements. Now I want to change the contents of some cells.

Example:
Manufacturer part number may be 110-A. I need to change that to KN-110-A.

In other words, I need to add KN- to @4500 part numbers in a column. The
manufacturer part numbers do not always follow a specific format (numbers
only, no hyphens, letters etc.) I know there is a way to do this easily or
relatively easy, I searched the help files but came up empty. Any help?

Modifying a range of cells
 

I think I understand, my mind was simply going in a different direction like
a search and replace function. Thanks.

"Barb Reinhardt" wrote:

You can do this with a helper column.

="KN-" & A1

Where A1 is the cell address containing the part number. Or do you want to
do this repeatedly and need a macro?
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"JimJ" wrote:

I have an imported spreadsheet that I am incorporating into my online store.
It contains about 4500 records. I made a CSV copy to comply with the web
requirements. Now I want to change the contents of some cells.

Example:
Manufacturer part number may be 110-A. I need to change that to KN-110-A.

In other words, I need to add KN- to @4500 part numbers in a column. The
manufacturer part numbers do not always follow a specific format (numbers
only, no hyphens, letters etc.) I know there is a way to do this easily or
relatively easy, I searched the help files but came up empty. Any help?