Splitting text strings in Excel - TechRepublic
General discussion
October 24, 2000 at 04:28 AM
robert.mcneill

Splitting text strings in Excel

by robert.mcneill . Updated 25 years, 7 months ago

Is there a function that allows you to split a text string with a space (s)
> in it into two or three different cells?
>
> For example, folks around here do not create discrete fields for first
> name and last name, just one field such as Firstname Lastname. I like
> to use the information for a mail merge, but can not create a salutation
> using only the first name as it is not a discrete text string.
>
> Any ideas?
>
> Thank you.

This discussion is locked

All Comments