|
|
#1
05-13-2013, 07:08 AM
|
|||
|
|||
no space in the cells
Dear Sir/Madam
Please kindly find attached file name Text. We would like to make the cells without any space at the front of the cells . like A3 , after programme, the results will be D3. How to make a small programme or formula? Thanks Tom 
|
|
#2
05-13-2013, 12:09 PM
|
||||
|
||||
|
Try the TRIM() function
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 autocorrect double space to single space
|
frankjake | Word | 8 | 09-21-2018 05:44 PM |
| In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only | mag | Excel | 0 | 10-28-2012 08:04 PM |
|
How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
|
Is this a Tab space or Indentation space?
|
Jamal NUMAN | Word | 1 | 06-30-2011 05:09 PM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Windows 7 64bit 
Office 2007
Linear Mode
