asked on 11/18/2014

Why is a template to separate numbers from text in a excel spreadsheet no longer working?

A template to separate data in mixed format in an Excel column no longer functions.

23 Echo Lane

Could be separated by:
=LEFT(A2,FIND(" ",A2)-1) pasted into a new adjacent blank column
and
=REPLACE(A2,1,FIND(" ",A2,"")
pasted into a new adjacent blank column on the opposite side of the target column

resulted in:

23 in one column and Echo Lane in another column with the original column in between the two new columns

Now an error "#NAME?" is returned instead of the parsing of the data.

Microsoft Applications Spreadsheets Office Productivity

Last Comment

Howie Kay

11/19/2014

SOLUTION

Patrick Matthews

11/18/2014

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

ASKER CERTIFIED SOLUTION

Eric Flamm

11/18/2014

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

SOLUTION

Eric Flamm

11/18/2014

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Howie Kay

11/19/2014

ASKER

Its a standalone page, just a typed in listing of names and addresses. It was an .xls and I saved it as a macro enabled spreadsheet. I'll try and save it as the latest extension xlsx. I saved as separate files. The templates failed in each one. Do you think there is something in the spreadsheet causing this? I receive 10 spreadsheets from separate sources. This is the first one with mixed address columns. I'll create a test spreadsheet and see if the templates work.
Thanks,
Howie

Microsoft Applications

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

45K

Questions

Followers

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY