Hi Akshu,
The best and quick way is "Text - to -Column" feature of the excel.
I believe, if we do it by a function then we might have to drag that to the
end of the columns/ rows (IV or 65536) or else VBA is the sure shot answer
for your query.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.)
Please check out the attachment.
Regards,
Mudassar Ramzan
- Original Message -
From: Akshu Bhagat
To: excel-macros@googlegroups.com
Sent: Wednesday, June 03, 2009 3:46 PM
Subject: $$Excel-Macros$$ Urgent help to split the column values
Hi everyone,
I want each name of
