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
LVL 8
Naresh PatelTraderAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
ok here it is. This one was a challenge !!! tks to keep those challenges coming :)
replacing "|" by ","
gowflow
Incoporated-Download-File-V05.xlsm
0
 
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
 
als315Connect With a Mentor Commented:
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.