noboffinme
New Member
- Joined
- Jun 30, 2011
- Messages
- 13
Hi
I've tried to use the Replace function in VBA & then recording a macro to replace all the '?' in a column on a csv spreadsheet with a blank value.
The other values are numbers such as 1.7.
I find using replace deletes all the data in that column or if I select the whole spreadsheet, replace will replace all of the values.
The column datatype is General & I've tried enclosing the ? symbol in "" or '', but no success.
Does anyone know how I can replace a ? with an empty cell & what's going on here?
MS Excel version is 2007 if that helps. Cheers
I've tried to use the Replace function in VBA & then recording a macro to replace all the '?' in a column on a csv spreadsheet with a blank value.
The other values are numbers such as 1.7.
I find using replace deletes all the data in that column or if I select the whole spreadsheet, replace will replace all of the values.
The column datatype is General & I've tried enclosing the ? symbol in "" or '', but no success.
Does anyone know how I can replace a ? with an empty cell & what's going on here?
MS Excel version is 2007 if that helps. Cheers