Data to transfer from column to row

qwerty70

Guest

Posts: n/a

21st Mar 2006

Dear All,

I have a cell that contains like:

PM-1234, PM-2345, PM-5689, PM-9999. I want to segregate these 4 tag
into rows.

i.e.,
PM-1234
PM-2345
PM-5689
PM-9999

Is there any excel guru out there to help in my problem???

Your help is greatly appreciated.

Thank you,

qwerty7

--
qwerty7
-----------------------------------------------------------------------
qwerty70's Profile: http://www.excelforum.com/member.php...fo&userid=3267
View this thread: http://www.excelforum.com/showthread.php?threadid=52474

« How to evaluate a string as a formula? | Data Validation - Named Range in external books »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
transfer data to another column removing blanks	sam	Microsoft Excel Misc	8	18th Jun 2009 07:15 AM
Data to transfer from column to row	qwerty70	Microsoft Excel Discussion	2	21st Mar 2006 12:59 PM
transfer data from one column into another column	=?Utf-8?B?V2Vzc2Vs?=	Microsoft Excel Misc	5	11th Jan 2006 11:48 PM
How do I quickly transfer data from a column into a row?	=?Utf-8?B?U2hhdW4=?=	Microsoft Excel Misc	5	12th Nov 2004 06:59 PM
i need to transfer all the even data points from column A to colu.	=?Utf-8?B?bWs=?=	Microsoft Excel Worksheet Functions	1	30th Sep 2004 11:49 PM