• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

Follow Up Bdel

Hi Experts,

This is follow up of Bdel now need to replace "|" to "," in downloaded - UnZip - .txt files.

See attached

Thanks
Incoporated-Download-File-V04.xlsm
0
Naresh Patel
Asked:
Naresh Patel
2 Solutions
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I don't know where you are talking about, as your question is unfocused, but to replace | for , in Excel, use

=Substitute(a1,"|",",")

and in VBA use

=Replace(strString,"|",",")
0
 
als315Commented:
0
 
gowflowCommented:
ok here it is. This one was a challenge !!! tks to keep those challenges coming :)
replacing "|" by ","
gowflow
Incoporated-Download-File-V05.xlsm
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Naresh PatelTraderAuthor Commented:
I am in dilemma to how to split points. So apology if I misjudge.

Mr.als315,      
Your File worked perfect but it is creating .bak files too, which is not required.

Sir.Gowflow,
Your file working Perfect.

Thanks
0
 
Naresh PatelTraderAuthor Commented:
May I ask follow-up Question?
0
 
gowflowCommented:
Yes pls go ahead as weekend off !
gowflow
0
 
Naresh PatelTraderAuthor Commented:
Here it is "FO Formatting".

Thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now