Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2012, 05:14 AM
gsrikanth gsrikanth is offline x,y,z coordinates with single space "need tab" Windows XP x,y,z coordinates with single space "need tab" Office XP
Competent Performer
x,y,z coordinates with single space "need tab"
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default x,y,z coordinates with single space "need tab"


any macro in excel

if i past 383644 1983816 255
"space" replace "tab"
X in A1
Y IN B1
Z IN C1
Reply With Quote
  #2  
Old 07-07-2012, 08:16 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline x,y,z coordinates with single space "need tab" Windows 7 32bit x,y,z coordinates with single space "need tab" Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Use text to columns with a space delimiter.
Reply With Quote
Reply

Thread Tools
Display Modes


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
x,y,z coordinates with single space "need tab" Outlook 2007: "The drive that contains your data file is out of disk space....." CLAWS Outlook 1 12-18-2011 11:54 PM
x,y,z coordinates with single space "need tab" The heading doesn't "obey" the "before" space! why? Jamal NUMAN Word 1 07-06-2011 04:25 AM
x,y,z coordinates with single space "need tab" Replacing a single "l" with a double "ll" MShroff Word 8 01-19-2011 08:43 AM
x,y,z coordinates with single space "need tab" Outlook 2007 - Receiving Multiple "read receipts" from a single email garp2100 Outlook 1 12-03-2010 07:10 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft