Replace "-" with tab

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ZUZ3L - 17 Dec 2007 10:17 GMT

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...

Reply to this Message

Ron Rosenfeld - 17 Dec 2007 10:49 GMT

>Hi
>
[quoted text clipped - 11 lines]
>
>Thank you for your time...

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

Reply to this Message

Alex Turner - 17 Dec 2007 10:52 GMT

> Hi
>
[quoted text clipped - 11 lines]
>
> Thank you for your time...

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?

Signature

http://nerds-central.blogspot.com/2007/12/baby-steps-how-to-become-excel-
god.html

Reply to this Message

Rate this thread: