How to sort data that is split in merged cells

[Ankit_Kumar]

Hello Everyone,

I have data in which I want to sort the data, but my problem is few columns data is merged.

Column A contains Name and contact details.
Then column B consider the whole detail as 1 and merged the cells.
Same in column C.

Now I am sorting the data so its creating problem to sort it.

Thanks
Ankit

[David A Coop]

Hi again Ankit,

It would help to see the sheet, but as a general rule, I NEVER use Merge cells for exactly this reason. I always format as Center Across Selection.

You will need to get rid of the Merge & Center cells.

I hope this helps, please let me know!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.