TTC - Text To Columns!
Select the data, then simply open and close TTC.
Select the data (in a single row),
<Data <TextToColumns <Finish
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don" wrote in message
...
In some Excel files, both native and those created with data imported from
a
tab delimited file, many or all of the cells are populated with the ' (as
is)
character. This presents a problem when I would like to have cells
formatted
in a specific manner (i.e. dates/double integer). I have tried to
search/replace for the character to no avail. Does anyone have a surefire
way of removing this "exact" character enmasse?
Thanks,
Don
|