Trim

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
--
 
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.
 
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.
 
Back
Top