Trim

A

assi

I would like to know how to trim the data from one column?

Example: From: 010203-04/02/05 to 04/02/05


From 010203-04/02/05 to 010203.

Please anybody let me know how to us function or inpu formula?


Thank you!
--
 
K

Ken Wright

Select column, do data / Text to Columns / delimited / in 'other' box put a
hyphen -
Hit Next and then lose whichever column you don't want by choosing the 'do
not import' column option, or if you want both then just hit Ok till done.
 
D

Dave Peterson

I think I'd insert a couple of columns to the right of that column.

Then use Data|Text to columns.
Choose Delimited and use a dash as the other character.

It looks like that 04/02/05 is a date. Make sure you use the correct format mdy
or dmy or whatever for that field.
 
Top