Hi,
I have hugged data in one cell I want to split into separate columns like Name, Street, City, State and Zip code, I have attached screenshot and sample file.
Thanks in Advance
Farhangul
Hi,
I have hugged data in one cell I want to split into separate columns like Name, Street, City, State and Zip code, I have attached screenshot and sample file.
Thanks in Advance
Farhangul
Hello
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi YasserKhalil,
VBA code is not running can you send me this in Excel file?
Here's the file
Or formula solution
Enter formula in B3, copy across and down
Formula:Please Login or Register to view this content.
v A B C D E F 1 Need Like 2 Raw Data Name Street City State Zip Code 3 Isabella A Greene 9164 Trafalgar St , Taylor, MI 48180-2721 Isabella A Greene 9164 Trafalgar St Taylor MI 48180-2721 4 Isabella Gill 41116 Kensington , Clinton Township, MI 48038 Isabella Gill 41116 Kensington Clinton Township MI 48038 5 Isabella Lubczonok 545 Meadowdale St , Ferndale, MI 48220 Isabella Lubczonok 545 Meadowdale St Ferndale MI 48220 6 Isabella Madden 2100 Fishbeck Rd , Howell, MI 48843 Isabella Madden 2100 Fishbeck Rd Howell MI 48843 7 Isabella McKendry 4292 Meadows Ave , Grand Blanc, MI 48439 Isabella McKendry 4292 Meadows Ave Grand Blanc MI 48439 8 Isabelle Kavanaugh 30417 Norwich Drive , Novi, MI 48377 Isabelle Kavanaugh 30417 Norwich Drive Novi MI 48377 9 Isaiah Peete 1739 Santa Fe Trail , Hartland, MI 48353 Isaiah Peete 1739 Santa Fe Trail Hartland MI 48353
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks