Replace "-" with tab

Z

ZUZ3L

Hi

I have a question regarding replacement of a character with tabulator.

I have to replace "-" with tabulator for one column. The column has
several words separated with "-".

Looks like this: SFS-HV-AFS

I would like to have it seperated into several columns for each word.

If I could replace "-" with a press of tab, that would do it... But
hooow? :)

Thank you for your time...
 
R

Ron Rosenfeld

Hi

I have a question regarding replacement of a character with tabulator.

I have to replace "-" with tabulator for one column. The column has
several words separated with "-".

Looks like this: SFS-HV-AFS

I would like to have it seperated into several columns for each word.

If I could replace "-" with a press of tab, that would do it... But
hooow? :)

Thank you for your time...
Click to expand...

If what you want is to have the "-" separated segments in separate columns, try
the Data/Text to Columns wizard using "-" as the separator.
--ron
 
Top