Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
Current column width for below column is 87
But when I change column width to 114 or more data expands as shown in below
When I pasted with XL2BB range it shows as above but in my display it double as shows in image below
I have checked length of cells with =LEN()
and Length remains same but it's expanding as I expand column width.
Is there any solution for this?
| Book4 | |||
|---|---|---|---|
| A | |||
| 1 | OLS6583 - Spacious | Updated 4 Bedroom Home | Backyard Oasis | ||
| 2 | PAR980 - Spacious Condo | FREE Parking | Walk to Shuttle! | ||
| 3 | TES200 - Walk to Gameday | Jefferson Park Condo | Tesoro,TES201 - Brand New Condo | Walk to Empower Stadium | Tesoro,TES300 - Gameday Oasis | Private Balcony | Jefferson Park | Tesoro,TES301 - Contemporary Condo | Grill + Balcony | Tesoro,TES400 - Luxuriou | ||
| 4 | PIR1026 - Amazing House! Downtown Walk EVERYWHERE Sleeps 10! 30+ | ||
| 5 | REB3328 - Stunning Guesthouse - Walk EVERYWHERE! Sleeps 4! | ||
| 6 | RIN201 - RiNo Art Lofts - Funky District - Walk Downtown! | ||
| 7 | RIN203 - RiNo Art Lofts - Stunning Colorful Modern Design | ||
| 8 | RIN207 - RiNo Art Lofts - Urban Cowboy Loft! Skyline Views! | ||
| 9 | RIN303 - RiNo Art Lofts - Modern Rustic Oasis - Sleeps 6! | ||
| 10 | ROE239 - Rustic MTN Escape | Grill + Fire pit | Blue River | ||
| 11 | SCH45 - Chic Copper/Frisco Condo | 4 Min Walk to Lift | ||
| 12 | SCH56 - Stunning New Copper Condo | Next to Ski Lifts | ||
| 13 | SCH3038 - Colorful Modern | Roof Deck | City Park Haven | ||
| 14 | SHU1655 - Chic City Park Home | Rooftop Deck + Skyline Views | ||
| 15 | SIM6078 - Foothills Panorama | 5 Bedrooms | Near Univ of CO! | ||
| 16 | STR56 - Cozy Breathtaking Mountain View | Close to Lifts | ||
| 17 | SWA3408 - New Townhome with Stunning City and Mountain Views | ||
| 18 | TAY910 - Amazing Amenities | Steps from Copper Lifts | ||
| 19 | TER9659 - Secluded & Spacious Mountain Getaway | ||
| 20 | VON1271 - Garden Apartment in a Stately Capitol Hill Victorian House | ||
| 21 | WAL1318 - Fresh Decor | 2bed Getaway | Walk to Sloan's Lake! | ||
| 22 | WIE8023 - Mountain Farmhouse Condo | Rocky MTN Vista View | ||
| 23 | WIL8 - Majestic Lodge Retreat | Amenities + Views!! | ||
| 24 | WOL1777 - Beautiful City Views in the Center of Everything! | ||
| 25 | WOO1773 - N Capitol Hill | Stylish 2-Bedroom | Back Patio | ||
| 26 | WYL240 - Mountain Views Galore | Avon Condo | Walk to Town | ||
| 27 | YEE1020 - Stunning Historic Home in Perfect Location 30+ | ||
| 28 | ESP202 - Art-Inspired Loft w/ Mountain View | EspadÃn LoHi,YIN2131 - Roof Deck! Walk to Parks and St. Joseph Hospital! | ||
| 29 | RAM1777 - Centrally Located - Coors Field - Downtown! | ||
| 30 | ZIC1777 - Luxe LoDo Apt - Free Parking - Gym & Pool!! 30+ | ||
Sheet1 | |||
But when I change column width to 114 or more data expands as shown in below
When I pasted with XL2BB range it shows as above but in my display it double as shows in image below
I have checked length of cells with =LEN()
and Length remains same but it's expanding as I expand column width.
Is there any solution for this?
