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>
 
Todd

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

Andy.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Data from One Worksheet to Many Automatically 3
VBA Excel partial cell compare to another cell 0
Lookup/count blank cells problem 9
formatting within a cell 1
splitting up information in a cell 1
Spliting a cell with multiple entries into seperate rows 1
Cut some of the data in a cell and move to the neext cell 4
Split cell based on uppercase letter 2

Back
Top