How to substitute all comma in this excel file?

lfbh222

New Member
Joined
Feb 2, 2015
Messages
32
I want to substitute all comma in this file by "\", but I cannot use the substitute function to do this, so can somebody help to figure it out?

Here is the text in the file(it contains several comma):


[TABLE="width: 845"]
<colgroup><col></colgroup><tbody>[TR]
[TD] Twitpic - Share photos and videos on Twitter - Awww\ that's a bummer. You shoulda got David Carr of Third Day to do it. ;D[/TD]
[/TR]
[TR]
[TD]is upset that he can't update his Facebook by texting it... and might cry as a result School today also. Blah![/TD]
[/TR]
[TR]
[TD]@Kenichan I dived many times for the ball. Managed to save 50% The rest go out of bounds[/TD]
[/TR]
[TR]
[TD]my whole body feels itchy and like its on fire [/TD]
[/TR]
[TR]
[TD] no+not behaving at all. i'm mad. why am i here? because I can't see you all over there. [/TD]
[/TR]
[TR]
[TD]@Kwesidei not the whole crew [/TD]
[/TR]
[TR]
[TD]Need a hug [/TD]
[/TR]
[TR]
[TD]@LOLTrish hey long time no see! Yes.. Rains a bit ,only a bit LOL , I'm fine thanks , how's you ?[/TD]
[/TR]
[TR]
[TD]@Tatiana_K nope they didn't have it [/TD]
[/TR]
[TR]
[TD]@twittera que me muera ? [/TD]
[/TR]
[TR]
[TD]spring break in plain city... it's snowing [/TD]
[/TR]
[TR]
[TD]I just re-pierced my ears [/TD]
[/TR]
[TR]
[TD]@caregiving I couldn't bear to watch it. And I thought the UA loss was embarrassing . . . . .[/TD]
[/TR]
[TR]
[TD]@octolinz16 It it counts, idk why I did either. you never talk to me anymore [/TD]
[/TR]
[TR]
[TD]@smarrison i would've been the first, but i didn't have a gun. not really though, zac snyder's just a doucheclown.[/TD]
[/TR]
[TR]
[TD]@iamjazzyfizzle I wish I got to watch it with you!! I miss you and @iamlilnicki how was the premiere?![/TD]
[/TR]
[TR]
[TD]Hollis' death scene will hurt me severely to watch on film wry is directors cut not out now?[/TD]
[/TR]
[TR]
[TD]about to file taxes [/TD]
[/TR]
[TR]
[TD]@LettyA ahh ive always wanted to see rent love the soundtrack!![/TD]
[/TR]
[TR]
[TD]@FakerPattyPattz Oh dear. Were you drinking out of the forgotten table drinks? [/TD]
[/TR]
[TR]
[TD]@alydesigns i was out most of the day so didn't get much done [/TD]
[/TR]
[TR]
[TD]one of my friend called mea and asked to meet with her at Mid Valley today...but i've no time *sigh* [/TD]
[/TR]
[TR]
[TD]@angry_barista I baked you a cake but I ated it [/TD]
[/TR]
[TR]
[TD]this week is not going as i had hoped [/TD]
[/TR]
[TR]
[TD]blagh class at 8 tomorrow [/TD]
[/TR]
[TR]
[TD]I hate when I have to call and wake people up [/TD]
[/TR]
[TR]
[TD]Just going to cry myself to sleep after watching Marley and Me. [/TD]
[/TR]
[TR]
[TD]im sad now Miss.Lilly[/TD]
[/TR]
[TR]
[TD]ooooh.... LOL that leslie.... and ok I won't do it again so leslie won't get mad again [/TD]
[/TR]
[TR]
[TD]Meh... Almost Lover is the exception... this track gets me depressed every time. [/TD]
[/TR]
[TR]
[TD]some1 hacked my account on aim now i have to make a new one[/TD]
[/TR]
[TR]
[TD]@alielayus I want to go to promote GEAR AND GROOVE but unfornately no ride there I may b going to the one in Anaheim in May though[/TD]
[/TR]
[TR]
[TD]thought sleeping in was an option tomorrow but realizing that it now is not. evaluations in the morning and work in the afternoon! [/TD]
[/TR]
[TR]
[TD]@julieebaby awe i love you too!!!! 1 am here i miss you[/TD]
[/TR]
[TR]
[TD]@HumpNinja I cry my asian eyes to sleep at night [/TD]
[/TR]
[TR]
[TD]ok I'm sick and spent an hour sitting in the shower cause I was too sick to stand and held back the puke like a champ. BED now [/TD]
[/TR]
[TR]
[TD]@cocomix04 ill tell ya the story later not a good day and ill be workin for like three more hours...[/TD]
[/TR]
[TR]
[TD]@MissXu sorry! bed time came here (GMT+1) Paparazzi![/TD]
[/TR]
[TR]
[TD]@fleurylis I don't either. Its depressing. I don't think I even want to know about the kids in suitcases. [/TD]
[/TR]
[TR]
[TD]Bed. Class 8-12. Work 12-3. Gym 3-5 or 6. Then class 6-10. Another day that's gonna fly by. I miss my girlfriend [/TD]
[/TR]
[TR]
[TD]really don't feel like getting up today... but got to study to for tomorrows practical exam... [/TD]
[/TR]
[TR]
[TD]He's the reason for the teardrops on my guitar the only one who has enough of me to break my heart [/TD]
[/TR]
[TR]
[TD]Sadand sadand sad. I don't know why but I hate this feeling I wanna sleep and I still can't![/TD]
[/TR]
[TR]
[TD]@JonathanRKnight Awww I soo wish I was there to see you finally comfortable! Im sad that I missed it [/TD]
[/TR]
[TR]
[TD]Falling asleep. Just heard about that Tracy girl's body being found. How sad My heart breaks for that family.[/TD]
[/TR]
[TR]
[TD]@Viennah Yay! I'm happy for you with your job! But that also means less time for me and you... [/TD]
[/TR]
[TR]
[TD]Just checked my user timeline on my blackberryand it looks like the twanking is still happening Are ppl still having probs w/ BGs and UIDs?[/TD]
[/TR]
[TR]
[TD]Oh man...was ironing @jeancjumbe's fave top to wear to a meeting. Burnt it [/TD]
[/TR]
[TR]
[TD]is strangely sad about LiLo and SamRo breaking up. [/TD]
[/TR]
[TR]
[TD]@tea oh! i'm so sorry i didn't think about that before retweeting.[/TD]
[/TR]
[TR]
[TD]Broadband plan 'a massive broken promise' http://tinyurl.com/dcuc33 via www.diigo.com/~tautao Still waiting for broadband we are [/TD]
[/TR]
[TR]
[TD]@localtweeps Wow, tons of replies from you, may have to unfollow so I can see my friends' tweets, you're scrolling the feed a lot. [/TD]
[/TR]
[TR]
[TD]our duck and chicken are taking wayyy too long to hatch [/TD]
[/TR]
[TR]
[TD]Put vacation photos online a few yrs ago. PC crashedand and now I forget the name of the site. [/TD]
[/TR]
[TR]
[TD]I need a hug [/TD]
[/TR]
[TR]
[TD]@andywana Not sure what they are, only that they are PoS! As much as I want to, I dont think can trade away company assets sorry andy! [/TD]
[/TR]
[TR]
[TD]@oanhLove I hate when that happens... [/TD]
[/TR]
[TR]
[TD]I have a sad feeling that Dallas is not going to show up I gotta say thoughand you'd think more shows would use music from the game. mmm[/TD]
[/TR]
[TR]
[TD]Ugh....92 degrees tomorrow [/TD]
[/TR]
[TR]
[TD]Where did u move to? I thought u were already in sd. ?? Hmmm. Random u found me. Glad to hear yer doing well.[/TD]
[/TR]
[TR]
[TD] I miss my ps3\ it's out of commission Wutcha playing? Have you copped 'Blood On The Sand'?[/TD]
[/TR]
[TR]
[TD]just leaving the parking lot of work! [/TD]
[/TR]
[TR]
[TD]The Life is cool. But not for Me. [/TD]
[/TR]
[TR]
[TD]Sadly though \ I've never gotten to experience the post coitus cigarette before \ and now I never will. [/TD]
[/TR]
[TR]
[TD]I had such a nice day. Too bad the rain comes in tomorrow at 5am [/TD]
[/TR]
[TR]
[TD]@Starrbby too bad I won't be around I lost my job and can't even pay my phone bill lmao aw shucks [/TD]
[/TR]
[TR]
[TD]Damm back to school tomorrow [/TD]
[/TR]
[TR]
[TD]Mo jobs, no money. how in the hell is min wage here 4 f'n clams an hour?[/TD]
[/TR]
[TR]
[TD]@katortiz Not forever... See you soon![/TD]
[/TR]
[TR]
[TD]@Lt_Algonquin agreed, I saw the failwhale allllll day today. [/TD]
[/TR]
[TR]
[TD]@jdarter Oh! Haha... dude I dont really look at em unless someone says HEY I ADDED YOU. Sorry I'm so terrible at that. I need a pop up![/TD]
[/TR]
[TR]
[TD]@ninjen I'm sure you're right... I need to start working out with you and the Nikster... Or Jared at least![/TD]
[/TR]
[TR]
[TD]i really hate how people diss my bands! Trace is clearly NOT ugly![/TD]
[/TR]
[TR]
[TD]Gym attire today was: Puma singlet, Adidas shorts.......and black business socks and leather shoes Lucky did not run into any cute girls.[/TD]
[/TR]
[TR]
[TD]Why won't you show my location?! Twitpic - Share photos and videos on Twitter[/TD]
[/TR]
[TR]
[TD]No picnic my phone smells like citrus.[/TD]
[/TR]
[TR]
[TD]@ashleyac My donkey is sensitive about such comments. Nevertheless, he'd (and me'd) be glad to see your mug asap. Charger is still awol. [/TD]
[/TR]
[TR]
[TD]No new csi tonight. FML[/TD]
[/TR]
[TR]
[TD]i think my arms are sore from tennis [/TD]
[/TR]
[TR]
[TD]wonders why someone that u like so much can make you so unhappy in a split seccond . depressed . [/TD]
[/TR]
[TR]
[TD]sleep soon... i just hate saying bye and see you tomorrow for the night. [/TD]
[/TR]
[TR]
[TD]@statravelAU just got ur newsletter, those fares really are unbelievable, shame I already booked and paid for mine [/TD]
[/TR]
[TR]
[TD]missin' the boo [/TD]
[/TR]
[TR]
[TD]@markhardy1974 Me too #itm[/TD]
[/TR]
[TR]
[TD]****... I don't have any chalk! MY CHALKBOARD IS USELESS [/TD]
[/TR]
[TR]
[TD]had a blast at the Getty Villa, but hates that she's had a sore throat all day. It's just getting worse too [/TD]
[/TR]
[TR]
[TD]@msdrama hey missed ya at the meeting sup mama[/TD]
[/TR]
[TR]
[TD]My tummy hurts. I wonder if the hypnosis has anything to do with it? If so, it's working, I get it, STOP SMOKING!!![/TD]
[/TR]
[TR]
[TD]why is it always the fat ones?! [/TD]
[/TR]
[TR]
[TD]@januarycrimson Sorry, babe!! My fam annoys me too. Thankfully, they're asleep right now. Muahaha. *evil laugh*[/TD]
[/TR]
[TR]
[TD]@Hollywoodheat I should have paid more attention when we covered photoshop in my webpage design class in undergrad [/TD]
[/TR]
[TR]
[TD]wednesday my b-day! don't know what 2 do!! [/TD]
[/TR]
[TR]
[TD]Poor cameron (the hills) [/TD]
[/TR]
[TR]
[TD]pray for me please, the ex is threatening to start sh** at my/our babies 1st Birthday party. what a jerk. and I still have a headache [/TD]
[/TR]
[TR]
[TD]@makeherfamous hmm , do u really enjoy being with him ? if the problems are too constants u should think things more , find someone ulike[/TD]
[/TR]
[TR]
[TD]Strider is a sick little puppy http://apps.facebook.com/dogbook/profile/view/5248435[/TD]
[/TR]
[TR]
[TD]so rylee,grace...wana go steve's party or not?? SADLY SINCE ITS EASTER I WNT B ABLE 2 DO MUCH BUT OHH WELL.....[/TD]
[/TR]
[TR]
[TD]hey, I actually won one of my bracket pools! Too bad it wasn't the one for money [/TD]
[/TR]
[TR]
[TD]@stark YOU don't follow me, either and i work for you![/TD]
[/TR]
[TR]
[TD]A bad nite for the favorite teams: Astros and Spartans lose. The nite out with T.W. was good.[/TD]
[/TR]
[TR]
[TD] Body Of Missing Northern Calif. Girl Found: Police have found the remains of a missing Northern California girl .. http://tr.im/imji[/TD]
[/TR]
[TR]
[TD]@mangaaa I hope they will increase the capacity fast, yesterday was such a pain. Got the fail whale +15 times in 2 hours.... [/TD]
[/TR]
[TR]
[TD]Behind on my classes for work [/TD]
[/TR]
[TR]
[TD]watching "House" [/TD]
[/TR]
[TR]
[TD]@kpreyes Remember my bum leg? Strikes back this time its serious [/TD]
[/TR]
[TR]
[TD]@paradisej cool, i will. their are all kinds of complaints about this laptop online about overheating, but no recalls [/TD]
[/TR]
[TR]
[TD]Emily will be glad when Mommy is done training at her new job. She misses her. http://apps.facebook.com/dogbook/profile/view/6176014[/TD]
[/TR]
[TR]
[TD]would rather the first party send bad messages than the 3rd party send mixed ones Sophmore year all over again?[/TD]
[/TR]
[TR]
[TD]@Henkuyinepu it's overrated [/TD]
[/TR]
[TR]
[TD]@marykatherine_q i know! I heard it this afternoon and wondered the same thing. Moscow is so behind the times [/TD]
[/TR]
[TR]
[TD]laying in bed with no voice.. [/TD]
[/TR]
[TR]
[TD]I'm sooo sad!!! they killed off Kutner on House whyyyyyyyy[/TD]
[/TR]
[TR]
[TD]@jacobsummers Sorry tell them mea culpa from me and that I really am sorry.[/TD]
[/TR]
[TR]
[TD]@Alliana07 it didn't make any sense to me, the suicide thing. I refuse to believe that that is actually what happened. [/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Paste all the data in a single cell

Eg:) Open a new excel , Copy the complete data that you need to substitute letter ,enter f2 in A1 cell and paste the data in that cell.

in B1 Cell enter this formula .

=SUBSTITUTE(A1,",","\")

Press enter

now copy the b1 cell and paste it in any cell as values . CTRL + C and ALT + E + S+ V

Done.

Thanks,
Harish
 
Upvote 0
thank you so much, it works
Paste all the data in a single cell

Eg:) Open a new excel , Copy the complete data that you need to substitute letter ,enter f2 in A1 cell and paste the data in that cell.

in B1 Cell enter this formula .



=SUBSTITUTE(A1,",","\")

Press enter

now copy the b1 cell and paste it in any cell as values . CTRL + C and ALT + E + S+ V

Done.

Thanks,
Harish
 
Upvote 0

Forum statistics

Threads
1,224,243
Messages
6,177,374
Members
452,773
Latest member
D P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top