Thanks.
On Mon, May 30, 2011 at 11:14 PM, Sixthsense sixthsense...@gmail.comwrote:
Hi Bharghav,
You can extract the data by using formula which will do the same work which
you are trying to derive by using the Text To Columns.
Change the cell reference A2 to your desired cell. This is a
Hi Bharghav,
You can extract the data by using formula which will do the same work which
you are trying to derive by using the Text To Columns.
Change the cell reference A2 to your desired cell. This is a single cell
formula which will get rotated when dragging the formula to the right and
down.
Hi ,
Thanks for the response. This did solve part of my problem.However when I
split the cell containing more than 255 characters using text to columns
options. I see only the first 255 characters getting split, others are just
ignored. Let me know how I can get away with this issue.
Other
Hi Bharghav,
This problem will occur when you perform the sheet *Move or Copy *option.
My suggestion is just press Cntrl+A twice, which will select all data in
your active worksheet and press Cntrl+C (to copy) and in New Worksheet Press
Cntrl+A and Press Cntrl+V (to paste). In this case the data
Hi All,
Looking forward to your reponses.
Rgds,
Bharghav Ramdas
On Tue, May 24, 2011 at 9:57 AM, Bharghav Ramdas bhargha...@gmail.comwrote:
Hi All,
I am currently working on an excel (2003)sheet whose cell character length
is beyond 255. I am able to copy just 255 characters. The remaining