Help

[chi]

Please help!

In a cell the data was entered like it was entered

e.g.

in the formula bar the data was entered like this

=John
Simon

I need the data to format like this

=John Simon

I was referring to the formula bar not the cell itself.
I'm familiar with Alignment wrap text. The problem goes
with the fomula bar there is a carriage return or the
data seem like the example above.

Hope you understand me.

Please help. Need to reformat data not doing it manualy.
Is there other way.

 

[Gord Dibben]

chi

If you have carriage returns in a cell you should be able to see them if you
turn off "text wrapping" on that cell.

You will see a square box at each return.

Try Edit>Replace

what: ALT + 0010(on numpad)
with: space(or nothing)

OR ALT + 0013

If this fails, try the CLEAN Function.

Post back if more is needed. There are a few other avenues of approach.

Gord Dibben Excel MVP