| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove ' from text columns
Hi,
This will remove the first character =MID(A1,2,LEN(A1)) Drag down If this leaves you with leading spaces try this =TRIM(MID(A1,2,LEN(A1))) If you really mean a ' at the start of each cell try this =MID(A1,FIND("'",A1,1)+1,LEN(A1)) Mike Mike "jackBlack via OfficeKB.com" wrote: There has to be a way to do this but I am missing it somewhere. I have exported some info from Access and now every cell contains a ' at the begining of the cell. I know how to remove that from cells with numbers in it but can't figure out the text cells. Any help? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200809/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open text file in Excel and remove columns | Excel Discussion (Misc queries) | |||
| how do I remove the automatic break lines in text to columns? | Excel Discussion (Misc queries) | |||
| Text to Columns - Way to remove all column breaks at one time? | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Hybrid Mode
