merge cells without losing data OR format

J

johncaleb

Need to merge A1 with B1.
Critical to retain the format of each cell.
A1 has text that is Left Justified. [JOHN ]
B1 has text that is Right Justified.[ SMITH]

Need the merged cell to retain each format. ie. [JOHN SMITH]

I know I cannot use the CONCATENAT function with the spaces, because the
text in B1 needs to be Right-Justified.

Is there another option?
please help.

thanks.
 
D

dlw

you cannot format one cell to be both right and left justified
instead of merging the cells, you have to concatenate them in a third cell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protect cell format 1
VBA Coding Help for Beginner 0
Combine two cells without losing data cell formats 3
Merging from an Excel file with graphics 1
How do I autofill spaces in right justified fields? 1
Problem with MS Word paragraph and character styles: format getting messed up 2
If, Or, and 5
Pivot Table loses formatting after refresh? 0

Top