Delete random space at the beginning of a cell before values

**davo3286** · 03-30-2020, 06:02 AM

Hello,

Due to a glitch in a system with a daily export, some values randomly have a space before the first letter which is giving my formulas some trouble.

Is there any code I could put on a macro button which I can then run once the export has been pasted over to my workbook, to tell that column there should not be a space before any value/character?

Thanks

**Pepe Le Mokko** · 03-30-2020, 06:04 AM

Perhaps use the TRIM function in your formulas?

**davo3286** · 03-30-2020, 06:32 AM

I've not seen those before - let me look into it - thanks!

**davo3286** · 03-30-2020, 06:38 AM

Worked perfectly and was so simple to use - thanks!

Delete random space at the beginning of a cell before values

LinkBack

Thread Tools

Rate This Thread

Display

Delete random space at the beginning of a cell before values

Re: Macro to delete random space at the beginning of a cell before values

Re: Macro to delete random space at the beginning of a cell before values

Re: Macro to delete random space at the beginning of a cell before values

Thread Information

Users Browsing this Thread

Similar Threads

delete first space in a cell

[SOLVED] Removing random amount of values after the first space from right

Excel 2007 : How to delete space at the beginning of a cell

Macro to generate random cell values by pct

delete space in cell

How do I remove a blanck space from the beginning of a formula?

Macro to delete space in front of date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions