Search and replace ALT+Enter
 

I have a very large workbook with multiple spreadsheets with frequesnt use of
ALT+ENTER within cells. I need to separate these data into columns using
Data- Text to Columns.

How do I do a Find for ALT+ENTER?

Search and replace ALT+Enter
 

Use ctrl-j

It may not look like you're typing anything, but give it a shot.

judykap wrote:

I have a very large workbook with multiple spreadsheets with frequesnt use of
ALT+ENTER within cells. I need to separate these data into columns using
Data- Text to Columns.

How do I do a Find for ALT+ENTER?

--

Dave Peterson

Search and replace ALT+Enter
 

Using Find/Replace, you can use CTRL-j, or ALT-010 in the Find box and
then Replace it with something else (like "|") so that your text-to-
columns can parse on the replacement character.

Hope this helps.

Pete

On Jun 23, 5:05*pm, judykap wrote:
I have a very large workbook with multiple spreadsheets with frequesnt use of
ALT+ENTER within cells. *I need to separate these data into columns using
Data- Text to Columns.

How do I do a Find for ALT+ENTER?

Search and replace ALT+Enter
 

Ctrl+J didn't seem to do anything. However, I just found ALT+ number pad
0009, so I've converted the line breaks to the asterisk character (*) then
Data-Text to Columns on the asterisk. It might not be the most efficient
method, but it seems to work.

Thanks.

"Dave Peterson" wrote:

Use ctrl-j

It may not look like you're typing anything, but give it a shot.

judykap wrote:

I have a very large workbook with multiple spreadsheets with frequesnt use of
ALT+ENTER within cells. I need to separate these data into columns using
Data- Text to Columns.

How do I do a Find for ALT+ENTER?

--

Dave Peterson

Search and replace ALT+Enter
 

if alt-0009 worked, then it wasn't the alt-enter that created the character.

Alt-0009 is the tab character.

So you could have avoided the edit|Replace and just used delimited by tab.

judykap wrote:

Ctrl+J didn't seem to do anything. However, I just found ALT+ number pad
0009, so I've converted the line breaks to the asterisk character (*) then
Data-Text to Columns on the asterisk. It might not be the most efficient
method, but it seems to work.

Thanks.

"Dave Peterson" wrote:

Use ctrl-j

It may not look like you're typing anything, but give it a shot.

judykap wrote:

I have a very large workbook with multiple spreadsheets with frequesnt use of
ALT+ENTER within cells. I need to separate these data into columns using
Data- Text to Columns.

How do I do a Find for ALT+ENTER?

--

Dave Peterson


--

Dave Peterson