Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2010, 12:03 AM
gfr gfr is offline Change <BR> to carriege Return Windows XP Change <BR> to carriege Return Office 2007
Novice
Change <BR> to carriege Return
 
Join Date: Mar 2010
Posts: 2
gfr is on a distinguished road
Default Change <BR> to carriege Return

Hi,
I have import some fields from MySQL to my Excel, but one of my fields has text in html format my datafield has <BR> is possible to change <BR>'s to ALT+ENTER ??

Thanks
Reply With Quote
  #2  
Old 03-18-2010, 12:51 AM
Matrix's Avatar
Matrix Matrix is offline Change &lt;BR&gt; to carriege Return Windows XP Change &lt;BR&gt; to carriege Return Office 2003
Admin
 
Join Date: Jan 2005
Posts: 429
Matrix is on a distinguished road
Default

Use Edit > Find > Replace, fill in <BR> for Find What, for Replace With, hold down alt and type 010, release alt key, then hold down alt and type 013. You may have to input the numbers with the numeric keypad.

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change &lt;BR&gt; to carriege Return Double return changes font oldecurb Word 11 03-06-2016 02:36 PM
Return mailing address disappears in options brian8723 Word 0 03-11-2010 09:54 AM
Auto forward return receipt to Requestor sarav@msoutlook Outlook 0 12-09-2008 06:34 AM
How do I return from a cross reference? smoggymark Word 0 10-21-2008 07:45 PM
Help with Max or lookup fomula to return a name forAmaxValue dutch4fire23 Excel 0 07-28-2006 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 AM.


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