| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Address can not be more than 30 characters
Hello,
I have a report that is opened through excel and it includes an address column. I am sending this report to a thrid party who can not have the address field be more than 30 characters. Is there a formula that would recognize if the field is more than 30 characters and then move the extra characters to the next column? the report includes over 1,000 records so it would be nice if I did not have to do any manual work. Thank you, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
| Using =address to provide address location for =average | Excel Worksheet Functions | |||
Threaded Mode
