| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Please help me with altering text in excel
I have imported text data and it is surrounded by double quotes "" How do I
get rid of them without going through each cell |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Please help me with altering text in excel
One way, assuming source in A1 down
Put in B1: =SUBSTITUTE(A1,"""","") Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mark" wrote: I have imported text data and it is surrounded by double quotes "" How do I get rid of them without going through each cell |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Please help me with altering text in excel
ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will delete any character you choose.......... Vaya con Dios, Chuck, CABGx3 "mark" wrote: I have imported text data and it is surrounded by double quotes "" How do I get rid of them without going through each cell |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Please help me with altering text in excel
Very impressive add on thankyou..did the trick !
"CLR" wrote: ASAP Utilities, a free add-in available at www.asap-utilities.com has a feature that will delete any character you choose.......... Vaya con Dios, Chuck, CABGx3 "mark" wrote: I have imported text data and it is surrounded by double quotes "" How do I get rid of them without going through each cell |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Please help me with altering text in excel
You're welcome.........thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "mark" wrote: Very impressive add on thankyou..did the trick ! "CLR" wrote: ASAP Utilities, a free add-in available at www.asap-utilities.com has a feature that will delete any character you choose.......... Vaya con Dios, Chuck, CABGx3 "mark" wrote: I have imported text data and it is surrounded by double quotes "" How do I get rid of them without going through each cell |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Please help me with altering text in excel
Highlight your range then ctrl+H
Find what: "" Replace: leave it blank Click Replace All "mark" wrote: I have imported text data and it is surrounded by double quotes "" How do I get rid of them without going through each cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
| How paste text from note pad to excel w/o using (Text to column) f | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Linear Mode
