Cut and copy

singcbl

Well-known Member
Joined
Feb 8, 2006
Messages
518
I like a quick and easy way to cut the text to the left of the first space of the active cell and paste that on to the cell on the left. Example as shown
Book2
ABCD
41.01Thequickbrownfoxjumpsoverthelazydog.
51.01Thequickbrownfoxjumpsoverthelazydog.
Sheet1
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
See if this works for you:
1. Move the whole text to the left hand cell (Cut & Paste or just drag cell border)
2. Data|Text to Columns..|Fixed Width|Next|Remove all the column breaks except between the number and the text|Finish
 
Upvote 0
Lewiy,

Thanks for the help. It serving what I need to do. I just need to do one more step and that is to copy paste special to convert the formula into text.

Peter_SSs,

Thanks for the suggestion but Lewiy proposed method serve my need better.
 
Upvote 0
Without VBA you would have to do this manually, however, if you wanted to do the whole thing via a macro (and bear in mind this is based purely on your single example):
Code:
Sub MyMacro()
[A2] = Left([B1], WorksheetFunction.Find(" ", [B1]) - 1)
[B2] = Right([B1], Len([B1]) - Len([A2]) - 1)
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,553
Messages
6,114,279
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top