Splitting data within a cell

T

Todd

Is it possible if you have two seperate types of data in
one cell over a wide range to automatically seperate the
two. For example if I have $400 5/30/82 in the same cell
and they are about 2 spaces apart, can I seperate them by
a few more spaces without having to go in there and
spacebar them apart? Thanks for the help.
 
J

J.E. McGimpsey

Select your cells and do a Edit/Replace:

Find what: <single space>
Replace with: <two spaces>
 
A

Andy B

Todd

Use Find/Replace to find " " and replace with " " - or whatever you
decide.

Andy.
 
Top