VBA code to split a cell at a space into 2 cells

[jtpryan]

I have a sheet with a column of data that looks like this:

thisisallonebigword nnn.n

So 2 parts separated by a space with the n=to numbers, seconds actually. Anyway I need to run down the column and split it into 2 columns, the text in one, the numbers in the next column. This is the last column in the sheet so I don't need to insert another one. I thought this would be simple but all I can find is (what seems to be) very complex answers.

Thank you all.

Jim

 

[Joe4]

You don't need VBA to do this. It can be done very easily using Text to Columns.
Just highlight your column, go to Text to Columns (from the Data menu), select Delimited, choose the Space as your delimiter, and click Finish.
If you want the VBA code equivalent, just turn on the Macro Recorder while you perform the steps above manually.

 

[jtpryan]

Joe,

I'm sorry, should have been clearer. This is part of a much larger VBA script that I am writing, so I do need a VBA solution.


Thank you for the quick reply.


Jim

 

[Joe4]

This is part of a much larger <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> script that I am writing, so I do need a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> solution.

Re-read my last line. The Macro Recorder is a VBA noob's best friend! You can get a lot of code snippets without having to write anything at all!

If you want the <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code equivalent, just turn on the Macro Recorder while you perform the steps above manually.

 

[jtpryan]

HA! You got me there, I totally missed that last line. I'll try it out. Thanks.