Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-29-2017, 09:23 AM
fdirosa fdirosa is offline Putting data in ranges within cell MS Excel 2007 Windows 7 64bit Putting data in ranges within cell MS Excel 2007 Office 2007
Novice
Putting data in ranges within cell MS Excel 2007
 
Join Date: Nov 2017
Posts: 2
fdirosa is on a distinguished road
Default Putting data in ranges within cell MS Excel 2007

Hello,

I looked all over the internet to find a way to collapse a string of data WITHIN a cell and I got only search results that show how to collapse and expand rows in Excel 2007 (which is NOT what I'm looking for).

I have a problem when importing a Bill Of Material from MS Excel 2007 into Any system. The issue is the cell data gets truncated where the reference designators are when there are hundreds of them

For example
R1, R2, R3, R6, R8, R9...R309, R310...

Import into any system only sees: R1, R2, R3, R6, R8, R9...R30

Bill Of Material initially saved as .XLS. I tried importing this file and didn't work as shown ex. above. After running MACRO (which MACRO does not work in Excel 2007 .XLSX file, only in .XLS), I saved file in .XLSX and then tried importing and same error. Then I tried copy from XLS. then paste as values in .XLSX and still same error.

Finally, I have an idea but don't know how to do this. I want to collapse reference designators into ranges WITHIN CELL like this (to save character space in cell):



R1, R2, R3, R6, R8, R9...R309, R310... --> R1-R3, R6, R9...R309-R310, etc.

How do I do this please?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? jsisley Excel 1 07-21-2017 09:20 AM
Putting data in ranges within cell MS Excel 2007 Populating ranking depending upon ranges of previous cell's data sryder Excel 5 04-07-2016 03:37 PM
How to replicate, consolidate and count cell data in excel for data consoldation. Loran Excel 7 06-05-2014 01:07 AM
Putting data in ranges within cell MS Excel 2007 Excel 2007, highlight entire row based on data found in one cell MSofficeBLUE Excel 2 10-15-2013 09:51 PM
Putting data in ranges within cell MS Excel 2007 putting image file into a cell of a table hklein Word VBA 1 04-19-2013 03:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft