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:

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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.
 
Upvote 0
Formula-wise perhaps:

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

and make sure the formula cells have cell format "wrap text" checked.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

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