Adding * to certain cells

wholesaleheating

New Member
Joined
Dec 6, 2005
Messages
19
Hi, I have a spreadsheet which contains the products to be imported into our ecommerce store. The details of a product rely upon two main columns:

Product Name | Primary Options

The first column "Product Name" contains repeated instances of the same data so for example:

Energy Efficient - Wall Mounted Gas Combi - Baxi - Combi HE
Energy Efficient - Wall Mounted Gas Combi - Baxi - Combi HE
Energy Efficient - Wall Mounted Gas Combi - Baxi - Combi HE

The second column contains the different options for this product eg:

Combi 105 HE
Combi Instant 105 HE
Combi Instant 80 HE

We have around 6000 products on our site and the new release of our ecommerce software requires each 1st primary option for each product to have a "*" before the text in the cell, eg:

*Combi 105 HE
Combi Instant 105 HE
Combi Instant 80 HE

Anybody know of a way I can automate the process of adding the "*" ?

Cheers
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

colbymack

Active Member
Joined
Jul 14, 2005
Messages
333
Insert a new column next to the second column.
Put this in the first cell:
=CONCATENATE("*",B1)

Put this in the second cell, and copy it all the way down:
=IF(A2=A1,B2,CONCATENATE("*",B2))

This assumes A is your Product Name column, and B is the Options column.

You can then use the Copy and Paste Special - Values option to replace the formulas with the values having the * included.

HTH,
Colbymack
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,546
Messages
5,838,018
Members
430,526
Latest member
NiceGuyWithExcel2007

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top