Cut some of the data in a cell and move to the neext cell

B

bischofg

I have data in a cell that contains Lat and Long data that is combined in one
cell with a comma between them. I need to seperate the data into two cells.
Example: -84.000001 39.000002. This needs to be 84.000001 in one cell and
39.000002 in another cell. I tried making a macro but with no luck.
 
P

Peo Sjoblom

Use data>text to column, select space as delimiter, make sure the next
column to the right is empty.
Record a macro while doing this

--


Regards,


Peo Sjoblom
 
P

Peo Sjoblom

-84.000001 39.000002

You are right, I didn't even read that part, I just saw the above which is
space delimited but the OP obviously said comma, my bad.

--


Regards,


Peo Sjoblom
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA Excel partial cell compare to another cell 0
Seperating information in a cell 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cobining various numbers of cells without using the & or concatena 2
How do I preserve text color when combining cell data 3
Apply Conditional Formatting If Data in More Than 1 Cell Matches 5
Need macro to move to first blank cell in column 6

Top