Macro to put data in a new column following specific characters

  • Thread starter Thread starter asf
  • Start date Start date
A

asf

I need to create a macro that goes through a single column, and ever
time a specific character set such as 3 periods "..." occurs anythin
after the "..." is put into a new column.

So say I have all of the following in column A:
I go...to the...store

I need it to turn into:
Column A:
I go
Column B:
to the
Column C:
store

Thanks in advance, any help is GREATLY appreciated!! :
 
If I needed to do this,

I'd select column A
edit|replace
what: ... (3 dots)
with: | (any unique character that doesn't appear any where in column A)
replace all

Then with column A still selected,
data|text to columns
delimited by the character you chose (|}
and plop it right on the worksheet.

If you really need a macro, record one when you do it manually.
 
Back
Top