Hi - I'm new to this, but wondering if there is a formula or macro to help with the following:
in Cell A1 to A5 I have:
24-dec-12
13-feb-14A
24-nov-89*
blank cell
19-may-12
What I want the formula to be able to do is display the following in cell B1 to B5:
24-dec-12
13-feb-14
24nov-89
blank cell
19-may-12
And in cells C1 to C5 it should show:
Blank cell
A
*
blank cell
blank cell
I have only shown 5 cells worth of data, however I have over 1000 cells I need to do. Thanks for trying to solve this.
Bookmarks