LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 47
Default Add a space in data

Hi,

Is there a formula that would add a space between two characters?

I have "12:13:09", I would like to add a space before the first colon. (12
:13:09)
--
smile
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to pick up data from left of a space starting from the right? Jim Thomlinson Excel Discussion (Misc queries) 0 August 15th 08 10:40 PM
Discovering No-BREAK Space in cell Data Joe Excel Discussion (Misc queries) 4 April 26th 07 01:46 PM
Paper Space / Model Space ? Coolboy55 Excel Discussion (Misc queries) 0 September 1st 05 08:58 PM
How do I shade the space between two data series in Excel? spike5150 Charts and Charting in Excel 1 March 23rd 05 11:19 PM
space between y axis and data points.. Dave R. Charts and Charting in Excel 3 January 8th 05 04:56 AM


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"