Dear Joel,
Actually I need just the name of companies which may be short or long, with
or without brackets or any other mark etc. Simply the question is that can we
separate the Text and numbers of a single cell.
Waiting for reply,

Thnaks & Regards


"Joel" wrote:

Supply some example of your data and how you want to seperate these items.
Text to column May work if you choose the delimted option, then hit next and
selected spaces.

"Tazeem" wrote:

How exactly text and numbers can be separated in an unmerged cell. There is
not a fixed number of digits in the available data so 'Text to column' option
does not work. Please help.

Thanks & Regards