• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 451
  • Last Modified:

add carriage return to excel formula for new line


I have a insert formual in an excel sheet,from here i copy it to atext file and run it into sql server

="insert into jobplan(Jpnum,description)values('"&A4&"','"&B4&"')go"

however I want the go in the about to appear on the second line like so

="insert into jobplan(Jpnum,description)values('"&A4&"','"&B4&"')
so my text file will look like this:

insert into jobplan(Jpnum,description)values('plan1','building')

how do I achieve this?
1 Solution
zorvek (Kevin Jones)ConsultantCommented:
="insert into jobplan(Jpnum,description)values('"&A4&"','"&B4&"')" & CHAR(10) & "go"

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now