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

add carriage return to excel formula for new line

folks

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&"')
go"
so my text file will look like this:

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

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

Kevin
0
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