It's no good saying "Waiting for reply"
You've been told about Data/ Text to columns/ delimited by spaces. If you
don't give any clearer idea as to how your data items are separated, then
you aren't going to get a clearer answer.
Or are you trying to say that you may have ABC123DEFG6789HJK456 and that you
want the ABCDEFGHJK in one cell and the 1236789456 in another cell?
--
David Biddulph

"Tazeem" wrote in message
...
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