We help IT Professionals succeed at work.

Excel Function

barnesco
barnesco asked
on
Medium Priority
217 Views
Last Modified: 2012-06-27
How would you create a function for the following:

U R* PIZZA GARDEN        03/30U R* AUST
to
PIZZA GARDEN

AND

Online Payment 1020751849 To Karen XXX 02/01
to
Karen XXX

Thanks. I'm new to Excel functions.
Comment
Watch Question

Engineer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
You need to explain the logic.

Commented:
the best direct way to do it is to convert the cell to table using the space as seperator, and then take the cell you want to make it in a new cell using concatinate fuction
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.