alt+enter HELLLLP

StephenIVI

New Member
Joined
Jan 29, 2013
Messages
16
Hello All,

I have a work sheet that has a column that has certain items in them that I want changed and I want the Alt+Enter function to be used.

What I have:
1" 3"
1" 8" 1"

What I would like:
1" (alt+Enter)
3"

OR

1" (alt+enter)
8" (alt+enter)
1"

I will be paying close attention to this thread so it may evolve into something else... THANK YOU FOR ALL THE HELP

Stephen
 
Last edited:

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to MrExcel.

Select your data and choose Edit|Replace. In the What box type a space. In the With box hold down Alt and type 010 on the numeric keypad. Then click Replace All.
 

Firefly2012

Well-known Member
Joined
Dec 28, 2011
Messages
3,638
Formula-wise perhaps:

=SUBSTITUTE(A1," ",CHAR(10))

and make sure the formula cells have cell format "wrap text" checked.
 

smilton

New Member
Joined
May 22, 2014
Messages
2

ADVERTISEMENT

How would you create this in VBA to loop through a range of cells?
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Start with the macro recorder to get the syntax. You shouldn't need to loop as the Replace method can be applied to a Range.
 

smilton

New Member
Joined
May 22, 2014
Messages
2
Thank you Andrew. I figured it out using the formula and am havig to create a CSV file, so I am using the macro to past values and it seams to be working pretty well.

Scott
 

Watch MrExcel Video

Forum statistics

Threads
1,122,298
Messages
5,595,310
Members
413,986
Latest member
Elizsk

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
Top