| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another replace question
Hey guys! Thanks for the help on the last question!
Here is another one. I have column A with this text: sometexthere=moretexthere What I need to do is make it like this with quotes: sometexthere="moretexthere" Any way to do this? Thanks!!! Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another replace question
Try:
=LEFT(A1,FIND("=",A1))&""""&TRIM(MID(A1,FIND("=",A 1)+1,255)) &"""" "Mike" wrote: Hey guys! Thanks for the help on the last question! Here is another one. I have column A with this text: sometexthere=moretexthere What I need to do is make it like this with quotes: sometexthere="moretexthere" Any way to do this? Thanks!!! Mike |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another replace question
Thanks Toppers!!!!
"Toppers" wrote: Try: =LEFT(A1,FIND("=",A1))&""""&TRIM(MID(A1,FIND("=",A 1)+1,255)) &"""" "Mike" wrote: Hey guys! Thanks for the help on the last question! Here is another one. I have column A with this text: sometexthere=moretexthere What I need to do is make it like this with quotes: sometexthere="moretexthere" Any way to do this? Thanks!!! Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Find and Replace Question | Excel Worksheet Functions | |||
| replace value in excel? | Excel Worksheet Functions | |||
| find replace format | Excel Discussion (Misc queries) | |||
| Search and Replace Question | New Users to Excel | |||
| Simple Search and Replace Question | Excel Discussion (Misc queries) | |||
Linear Mode
