Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm entering text folowed by a series of periods
example Source Four Barrels 19°, 26°, 36°, 50°€¦€¦€¦€¦€¦€¦€¦...€¦€¦€¦€¦€¦€¦€¦ €¦ with the hopes that the information will be displayed with the cell just to the right of it masking the last periods. If I leave a space between the ° and the .... the ..... will disappear depending on length if there is no space the 50°...................... all disappear completly I know this seems simple, but I'm entering the information into a spreadsheet with at least 500 items, so I need this to be a simpler process. I'm entering part description followed by ........ then the price cell to the right Any help would be much appreciated I could send anyone the file if needed. Also the dots print with some periods larger than the rest and they appear to be different sizes in the same cell after just holding down the period key the fill the rest of the cell. Tried to search for answers, but didn't find any. Thanks, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |