Replacing " "

wwbwb

Well-known Member
Joined
Oct 20, 2003
Messages
513
I'm looking for a macro that could take care of this. A search of the forum yeilded several thoughts, but none of them are sticking.

I have a sheet with part numbers, most are numeric, some are alphanumeric and a few are alphanumeric with spaces. On a seperate sheet I can print out inventory cards with barcodes. The user types in the part number and a barcoded card is produced. The only problem is with the spaces. The spaces will always, so far, occur in spots 4 and 5 (ex. 00w 123456). The barcode font doen't regognize a space so it needs to be replaced by a =. So what I was hoping is for a macro that replaces the " " in the part number with a "==". Ideas?
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
wwbwb said:
I'm looking for a macro that could take care of this. A search of the forum yeilded several thoughts, but none of them are sticking.

I have a sheet with part numbers, most are numeric, some are alphanumeric and a few are alphanumeric with spaces. On a seperate sheet I can print out inventory cards with barcodes. The user types in the part number and a barcoded card is produced. The only problem is with the spaces. The spaces will always, so far, occur in spots 4 and 5 (ex. 00w 123456). The barcode font doen't regognize a space so it needs to be replaced by a =. So what I was hoping is for a macro that replaces the " " in the part number with a "==". Ideas?

Have you tried Edit/Replace?
 

wwbwb

Well-known Member
Joined
Oct 20, 2003
Messages
513
thanks, why didn't I think of that, duh... Macro Recorder. Thanks again.
 

Forum statistics

Threads
1,148,218
Messages
5,745,444
Members
423,952
Latest member
EduardoM

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