Limiting the number of Characters in a cell

becca1 · May 23rd, 2002, 11:18 AM

I have used a formula before that counts the number of characters in a cell and deletes those after a specified point. I have a spreadsheet with and address column, in order to import this data into an internal software application I need to reduce the address to 30 characters. How do I do this?

Asala42 · May 23rd, 2002, 11:20 AM

Hey,

Can you get away with =LEFT(AddressCell,30)

Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 11:18 AM	#1
becca1 New Member Join Date: May 2002 Location: Rebecca Collins Posts: 1	I have used a formula before that counts the number of characters in a cell and deletes those after a specified point. I have a spreadsheet with and address column, in order to import this data into an internal software application I need to reduce the address to 30 characters. How do I do this?

May 23rd, 2002, 11:20 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,028	Hey, Can you get away with =LEFT(AddressCell,30) Adam