alt+enter HELLLLP

[StephenIVI]

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

 

[Andrew Poulsom]

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]

Formula-wise perhaps:

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

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

 

[StephenIVI]

THANK YOU!!! Fixed what I needed - - Huge help - - to the both of you!

 

[smilton]

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

 

[Andrew Poulsom]

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]

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