x,y,z coordinates with single space "need tab"

gsrikanth · #1 07-07-2012, 05:14 AM

any macro in excel

if i past 383644 1983816 255
"space" replace "tab"
X in A1

Y IN B1
Z IN C1

Colin Legg · #2 07-07-2012, 08:16 AM

Use text to columns with a space delimiter.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wierd symbols inplace of "space", "indentation" etc	aka.bhagvanji	Word	5	02-16-2012 11:50 AM
Outlook 2007: "The drive that contains your data file is out of disk space....."	CLAWS	Outlook	1	12-18-2011 11:54 PM
The heading doesn't "obey" the "before" space! why?	Jamal NUMAN	Word	1	07-06-2011 04:25 AM
Replacing a single "l" with a double "ll"	MShroff	Word	8	01-19-2011 08:43 AM
Outlook 2007 - Receiving Multiple "read receipts" from a single email	garp2100	Outlook	1	12-03-2010 07:10 AM