Splitting data within a cell

  • Thread starter Thread starter Todd
  • Start date Start date
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.
 
Select your cells and do a Edit/Replace:

Find what: <single space>
Replace with: <two spaces>
 
Back
Top