From 1 to 2 columns

S

Steved

Hello from Steved

McCovey Cove=Natural
Ned Devine=Harbor Prince
Te Maika=Imperial Seal

Please can I have a formula for the above
The above is in one Column
I do not want the = please
so instead of being in Column A
I would like Column A, Column B

McCovey Cove Natural
Ned Devine Harbor Prince
Te Maika Imperial Seal

Thanks.
 
P

Paul Corrado

No need for Edit/Replace. I believe you can just use Data/Text to Columns
and use "=" as the delimiting character.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Create a conditional formula that results in another calculation 10
Grouping {MERGEFIELD} into 2 or 3 Columns 0
How to ignore the in between cells? 0
Compare A&B columns with C&D columns 4
Sum of values in column A based on 0/1 of column B 2
Trying to count based on multiple criteria & cell comparisons 4
Hide columns based on row values 2

Top