Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-12-2011, 07:46 AM
kjxavier kjxavier is offline Find and Replace Windows XP Find and Replace Office 2007
Advanced Beginner
Find and Replace
 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Default Find and Replace

i have bulk email fields placed in a Column

but it seems there are some spaces between some email ID's



is it possible to remove all spaces from the column

i mean something like

Find=<space>
Replace with=(what will i replace with?)
Reply With Quote
  #2  
Old 08-12-2011, 12:05 PM
Catalin.B Catalin.B is offline Find and Replace Windows Vista Find and Replace Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

spaces means empty rows on that column, or what?
Reply With Quote
  #3  
Old 08-12-2011, 07:09 PM
kjxavier kjxavier is offline Find and Replace Windows XP Find and Replace Office 2007
Advanced Beginner
Find and Replace
 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Default Find and Replace

Quote:
Originally Posted by Catalin.B View Post
spaces means empty rows on that column, or what?
i just wrote like that <space>

actually i like to remove space (one single space not row or rows) in the field. i have many columns which contains E-mail ID's, sometimes there may be spaces between or middle or after the E-mail ID's because it is converted using some software. So, i like to take the spaces off the Email field.

I can find the space in the field with
Find=<space>(i mean a single space not any function) but i donno what to be replaced with

Replace with= ?
Reply With Quote
  #4  
Old 08-12-2011, 10:49 PM
Catalin.B Catalin.B is offline Find and Replace Windows Vista Find and Replace Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

you can use this formula in another column: =SUBSTITUTE(D8;" ";"")
or, with find and replace, in find what line type a space, in the replace with, do not type anything; just click replace all...this should work... good luck!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace Find and Replace kjxavier Word 6 08-19-2011 09:56 PM
Find and Replace Find and Replace kjxavier Word 9 08-11-2011 04:47 AM
Find and Replace Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM
find and replace anil3b2 Word 0 08-03-2010 11:30 PM
help with find and replace sjkiss Word 1 04-12-2010 08:08 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:17 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