Replace "-" with tab

  • Thread starter Thread starter ZUZ3L
  • Start date Start date
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...
 
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
 
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...

Your question is a little vague. If you are wanting to change the file
(csv format or something) before it is loaded into Excel, then a simple
script would do it. Otherwise, you could use function is a spreadsheet
to split each cell into multiple cells. Can you give us a little bit
more information as to what you are up to?
 
Back
Top